DBA Data[Home] [Help]

VIEW: SYS.CDB_MVIEW_KEYS

Source

View Text - Preformatted

SELECT "OWNER","MVIEW_NAME","POSITION_IN_SELECT","CONTAINER_COLUMN","DETAILOBJ_OWNER","DETAILOBJ_NAME","DETAILOBJ_ALIAS","DETAILOBJ_TYPE","DETAILOBJ_COLUMN","CON_ID" FROM CONTAINERS("SYS"."DBA_MVIEW_KEYS")
View Text - HTML Formatted

SELECT "OWNER"
, "MVIEW_NAME"
, "POSITION_IN_SELECT"
, "CONTAINER_COLUMN"
, "DETAILOBJ_OWNER"
, "DETAILOBJ_NAME"
, "DETAILOBJ_ALIAS"
, "DETAILOBJ_TYPE"
, "DETAILOBJ_COLUMN"
, "CON_ID"
FROM CONTAINERS("SYS"."DBA_MVIEW_KEYS")