DBA Data[Home] [Help]

VIEW: SYS.CDB_OBJECTS

Source

View Text - Preformatted

SELECT "OWNER","OBJECT_NAME","SUBOBJECT_NAME","OBJECT_ID","DATA_OBJECT_ID","OBJECT_TYPE","CREATED","LAST_DDL_TIME","TIMESTAMP","STATUS","TEMPORARY","GENERATED","SECONDARY","NAMESPACE","EDITION_NAME","SHARING","EDITIONABLE","ORACLE_MAINTAINED","CON_ID" FROM CONTAINERS("SYS"."DBA_OBJECTS")
View Text - HTML Formatted

SELECT "OWNER"
, "OBJECT_NAME"
, "SUBOBJECT_NAME"
, "OBJECT_ID"
, "DATA_OBJECT_ID"
, "OBJECT_TYPE"
, "CREATED"
, "LAST_DDL_TIME"
, "TIMESTAMP"
, "STATUS"
, "TEMPORARY"
, "GENERATED"
, "SECONDARY"
, "NAMESPACE"
, "EDITION_NAME"
, "SHARING"
, "EDITIONABLE"
, "ORACLE_MAINTAINED"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_OBJECTS")