Find nested tables in db - oracle database script

--- Script to find nested tables of a schema:  set pagesize 200 set lines 200 set long 999 col owner for a18 col table_name for a20 col table_type_owner for a20 col table_type_name for a20 col parent_table_name for a20 col parent_table_column for a20 SELECT owner, table_name, table_type_owner, table_type_name, parent_table_name, parent_table_column, LTRIM (storage_spec) storage_spec, LTRIM (return_type) return_type FROM dba_nested_tables WHERE owner='&SCHEMA_NAME' And upper(table_name) like '&&TABLE_NAME' ORDER BY owner;