Read domain code and value from sde 10 by oracle 10g

[AmmarAssem1]

I have sde 10 in oracle 10g and i need query that I can select code and value .

Thanks,
Best regards

[ForrestJones]

Hi Ammar,

Is this what you are looking for?

Example: Resolving domain codes to description values using SQL/

Remember to configure the extproc too if you are going to use the above method to query the xml in the gdb_ tables in oracle:

Configuring the Oracle listener to access the geodatabase with SQL