CODEWITHSUNDEEP
sqloracle-databasemetadata
morisil
morisil

Reputation: 1355

How to read type of element for Oracle collection type?

I have Oracle collection type defined as:

type tab_foo as table of obj_foo

Where obj_foo is defined as:

type obj_foo as object

By calling:

select * from sys.all_types where typecode = 'COLLECTION';

I can get metadata for all the collection types, however there is no information what is the type of element contained in the collection.

How to retrieve collection element type metadata from oracle?

Upvotes: 1

Views: 1271

Answers (1)

Dave Costa
Dave Costa

Reputation: 48121

Look at ALL_COLL_TYPES, which lists all collection types. The column you are interested in is ELEM_TYPE_NAME.

Upvotes: 3

Related Questions