How to get geodatabase subtype codes and descriptions using oracle

[santhoshT]

I have to read the geodatabase subtype data from oracle.

Could you please share the SQL query to get the sub-type

[Asrujit_SenGupta]

You may check the below links:

Example: Finding subtype codes and descriptions using SQL

SQL Select to get a subtype value from an ARC Database