How to know object type name for a object table? (Oracle)

Question

If a table is defined as "create table xxx as type_name" by sb. How can I know the type_name? (Oracle DB)

Answer 1

You can query the all_object_tables view.

SELECT table_type 
  FROM all_object_tables
 WHERE table_name = 'XXX'

Note that the syntax to create an object table of type type_name is:

CREATE TABLE xxx OF type_name; -- OF, not AS