select
awv.view_owner view_owner,
awv.view_name view_name,
col.name column_name,
awvc.awobject awobject
from olapsys.cwm2$awviews awv,
olapsys.cwm2$awviewcols awvc,
sys.col$ col
where awvc.awviews_irid = awv.irid and
awv.table_id = col.obj# and
awvc.column_id = col.col#
with read only
SELECT
AWV.VIEW_OWNER VIEW_OWNER
,
AWV.VIEW_NAME VIEW_NAME
,
COL.NAME COLUMN_NAME
,
AWVC.AWOBJECT AWOBJECT
FROM OLAPSYS.CWM2$AWVIEWS AWV
,
OLAPSYS.CWM2$AWVIEWCOLS AWVC
,
SYS.COL$ COL
WHERE AWVC.AWVIEWS_IRID = AWV.IRID AND
AWV.TABLE_ID = COL.OBJ# AND
AWVC.COLUMN_ID = COL.COL#
WITH READ ONLY
|
|
|