Have Geek Brain

Where is all_nested_table_cols in 9i?

Oracle 9i has nested tables, however it does not have sysview all_nested_table_cols (like 10g and 11g), which allows me to see which columns are for those nested tables. How can I find this information in the 9i database?

+2


a source to share


1 answer


I don't have a 9i instance to test, but maybe this can help you:

SELECT nt.owner, nt.table_name, nt.parent_table_name, nt.parent_table_column, ct.owner, ct.type_name, ta.*
  FROM all_nested_tables nt, all_coll_types ct, all_type_attrs ta
 WHERE ct.type_name = nt.table_type_name
   AND ta.type_name = ct.elem_type_name


The column attr_name

should be something like a column column_name

in all_nested_table_cols. I know this is not the real thing ... but this is the beginning.

Making this CW in case anyone wants to improve it.

0


a source






More articles:


All Articles