DBA Data[Home] [Help]

VIEW: SYS.CDB_NESTED_TABLES

Source

View Text - Preformatted

SELECT "OWNER","TABLE_NAME","TABLE_TYPE_OWNER","TABLE_TYPE_NAME","PARENT_TABLE_NAME","PARENT_TABLE_COLUMN","STORAGE_SPEC","RETURN_TYPE","ELEMENT_SUBSTITUTABLE","CON_ID" FROM CONTAINERS("SYS"."DBA_NESTED_TABLES")
View Text - HTML Formatted

SELECT "OWNER"
, "TABLE_NAME"
, "TABLE_TYPE_OWNER"
, "TABLE_TYPE_NAME"
, "PARENT_TABLE_NAME"
, "PARENT_TABLE_COLUMN"
, "STORAGE_SPEC"
, "RETURN_TYPE"
, "ELEMENT_SUBSTITUTABLE"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_NESTED_TABLES")