I have to read the geodatabase subtype data from oracle.
Could you please share the SQL query to get the sub-type
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