[Home] [Help]
Skip to content
VIEW: DVSYS.DV$SYS_OBJECT
Source
View Text - Preformatted
SELECT
OBJECT_ID
,OWNER
,OBJECT_NAME
,SUBOBJECT_NAME
,DATA_OBJECT_ID
,OBJECT_TYPE
,CREATED
,LAST_DDL_TIME
,TIMESTAMP
,STATUS
,TEMPORARY
,GENERATED
,SECONDARY
FROM sys.dba_objects
View Text - HTML Formatted
SELECT
OBJECT_ID
, OWNER
, OBJECT_NAME
, SUBOBJECT_NAME
, DATA_OBJECT_ID
, OBJECT_TYPE
, CREATED
, LAST_DDL_TIME
, TIMESTAMP
, STATUS
, TEMPORARY
, GENERATED
, SECONDARY
FROM SYS.DBA_OBJECTS