How to get the Type name of an unknown Type?

From: <tcdb4dan_at_yahoo.com>
Date: 26 Jul 2005 11:15:41 -0700
Message-ID: <1122401741.072174.174280@z14g2000cwz.googlegroups.com>

In Oracle10g, I have a Type with several Subtypes. I have an object table of that type in which I can store the master type or any of its subtypes. I know I can extract specific types with a where clause including IS OF (ONLY MYTYPE). But if I'm selecting all objects out of the table, is there a way to tell the type of each of the objects? The docs say to use SYS_TYPEID(), but that only returns a non-unique number.

TIA. Received on Tue Jul 26 2005 - 13:15:41 CDT