DBA Data[Home] [Help]

VIEW: ENG.ENG_CHANGE_OBJECTS#

Source

View Text - Preformatted

select OBJECT_ID OBJECT_ID, QUERY_OBJECT_NAME QUERY_OBJECT_NAME, QUERY_COLUMN1_NAME QUERY_COLUMN1_NAME, QUERY_COLUMN2_NAME QUERY_COLUMN2_NAME, QUERY_COLUMN3_NAME QUERY_COLUMN3_NAME, QUERY_COLUMN4_NAME QUERY_COLUMN4_NAME, QUERY_COLUMN5_NAME QUERY_COLUMN5_NAME, QUERY_COLUMN1_TYPE QUERY_COLUMN1_TYPE, QUERY_COLUMN2_TYPE QUERY_COLUMN2_TYPE, QUERY_COLUMN3_TYPE QUERY_COLUMN3_TYPE, QUERY_COLUMN4_TYPE QUERY_COLUMN4_TYPE, QUERY_COLUMN5_TYPE QUERY_COLUMN5_TYPE, CREATED_BY CREATED_BY, CREATION_DATE CREATION_DATE, LAST_UPDATE_DATE LAST_UPDATE_DATE, LAST_UPDATED_BY LAST_UPDATED_BY, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN, ENTITY_NAME ENTITY_NAME, PK1_COLUMN_NAME PK1_COLUMN_NAME, PK2_COLUMN_NAME PK2_COLUMN_NAME, PK3_COLUMN_NAME PK3_COLUMN_NAME, PK4_COLUMN_NAME PK4_COLUMN_NAME, PK5_COLUMN_NAME PK5_COLUMN_NAME, ENTITY_URL ENTITY_URL, ZD_EDITION_NAME ZD_EDITION_NAME from "ENG"."ENG_CHANGE_OBJECTS"
View Text - HTML Formatted

SELECT OBJECT_ID OBJECT_ID
, QUERY_OBJECT_NAME QUERY_OBJECT_NAME
, QUERY_COLUMN1_NAME QUERY_COLUMN1_NAME
, QUERY_COLUMN2_NAME QUERY_COLUMN2_NAME
, QUERY_COLUMN3_NAME QUERY_COLUMN3_NAME
, QUERY_COLUMN4_NAME QUERY_COLUMN4_NAME
, QUERY_COLUMN5_NAME QUERY_COLUMN5_NAME
, QUERY_COLUMN1_TYPE QUERY_COLUMN1_TYPE
, QUERY_COLUMN2_TYPE QUERY_COLUMN2_TYPE
, QUERY_COLUMN3_TYPE QUERY_COLUMN3_TYPE
, QUERY_COLUMN4_TYPE QUERY_COLUMN4_TYPE
, QUERY_COLUMN5_TYPE QUERY_COLUMN5_TYPE
, CREATED_BY CREATED_BY
, CREATION_DATE CREATION_DATE
, LAST_UPDATE_DATE LAST_UPDATE_DATE
, LAST_UPDATED_BY LAST_UPDATED_BY
, LAST_UPDATE_LOGIN LAST_UPDATE_LOGIN
, ENTITY_NAME ENTITY_NAME
, PK1_COLUMN_NAME PK1_COLUMN_NAME
, PK2_COLUMN_NAME PK2_COLUMN_NAME
, PK3_COLUMN_NAME PK3_COLUMN_NAME
, PK4_COLUMN_NAME PK4_COLUMN_NAME
, PK5_COLUMN_NAME PK5_COLUMN_NAME
, ENTITY_URL ENTITY_URL
, ZD_EDITION_NAME ZD_EDITION_NAME
FROM "ENG"."ENG_CHANGE_OBJECTS"