VIEW: SYS.KU$_VIEW_VIEW

Source

View Text - Preformatted

select '1','4',
         v.obj#,
         value(o),
         replace(v.audit$,chr(0),'-'),
         v.cols, v.intcols,
         bitand(v.property, 4294967295),
         trunc(v.property / power(2,32)),
         v.flags, v.textlength,
         sys.dbms_metadata_util.long2clob(v.textlength,
                                        'SYS.VIEW$',
                                        'TEXT',
                                        v.rowid),
         sys.dbms_metadata.parse_query(o.owner_name,
                                       v.textlength,
                                       'SYS.VIEW$',
                                       'TEXT',
                                       v.rowid,
                                       bitand(v.property,16384),
                                       (select
                                        case
                                         when exists
                                         (select cd.con# from cdef$ cd
                                          where cd.obj# = v.obj#
                                            and cd.type# = 5) then 1
                                          else 0
                                        end from dual)),
         (select value (t)
                 from sys.ku$_constraint0_view t, cdef$ cd
                  where cd.obj# = v.obj# and
                        t.con_num = cd.con# and
                        cd.type# = 5),
         NULL,
         cast(multiset(select * from ku$_simple_col_view c
                       where c.obj_num = v.obj#
                         and (bitand(v.property,1)=0)
                        order by c.intcol_num
                      ) as ku$_simple_col_list_t
             ),
         cast(multiset(select * from ku$_column_view c
                       where c.obj_num = v.obj#
                         and (bitand(v.property,1)=1)
                        order by c.intcol_num
                      ) as ku$_column_list_t
             ),
         tv.typeowner, tv.typename, tv.typetextlength, tv.typetext,
         tv.oidtextlength, tv.oidtext, tv.transtextlength,
         sys.dbms_metadata_util.long2varchar(tv.transtextlength,
                                        'SYS.TYPED_VIEW$',
                                        'TRANSTEXT',
                                        tv.rowid),
         tv.undertextlength,
         sys.dbms_metadata_util.long2varchar(tv.undertextlength,
                                        'SYS.TYPED_VIEW$',
                                        'UNDERTEXT',
                                        tv.rowid),
         cast( multiset(select * from ku$_constraint1_view con
                        where con.obj_num = v.obj#
                       ) as ku$_constraint1_list_t
             ),
         cast( multiset(select * from ku$_constraint2_view con
                        where con.obj_num = v.obj#
                       ) as ku$_constraint2_list_t
             )
  from sys.ku$_edition_schemaobj_view o, sys.obj$ oo, sys.view$ v, sys.typed_view$ tv
  where oo.obj# = o.obj_num
    and oo.obj# = v.obj#
    and oo.obj# = tv.obj# (+)
         AND (SYS_CONTEXT('USERENV','CURRENT_USERID') IN (o.owner_num, 0) OR
              EXISTS ( SELECT * FROM sys.session_roles
                       WHERE role='SELECT_CATALOG_ROLE' ))

View Text - HTML Formatted

SELECT '1'
, '4'
, V.OBJ#
, VALUE(O)
, REPLACE(V.AUDIT$
, CHR(0)
, '-')
, V.COLS
, V.INTCOLS
, BITAND(V.PROPERTY
, 4294967295)
, TRUNC(V.PROPERTY / POWER(2
, 32))
, V.FLAGS
, V.TEXTLENGTH
, SYS.DBMS_METADATA_UTIL.LONG2CLOB(V.TEXTLENGTH
, 'SYS.VIEW$'
, 'TEXT'
, V.ROWID)
, SYS.DBMS_METADATA.PARSE_QUERY(O.OWNER_NAME
, V.TEXTLENGTH
, 'SYS.VIEW$'
, 'TEXT'
, V.ROWID
, BITAND(V.PROPERTY
, 16384)
, (SELECT CASE WHEN EXISTS (SELECT CD.CON#
FROM CDEF$ CD
WHERE CD.OBJ# = V.OBJ#
AND CD.TYPE# = 5) THEN 1 ELSE 0 END
FROM DUAL))
, (SELECT VALUE (T)
FROM SYS.KU$_CONSTRAINT0_VIEW T
, CDEF$ CD
WHERE CD.OBJ# = V.OBJ# AND T.CON_NUM = CD.CON# AND CD.TYPE# = 5)
, NULL
, CAST(MULTISET(SELECT *
FROM KU$_SIMPLE_COL_VIEW C
WHERE C.OBJ_NUM = V.OBJ#
AND (BITAND(V.PROPERTY
, 1)=0) ORDER BY C.INTCOL_NUM ) AS KU$_SIMPLE_COL_LIST_T )
, CAST(MULTISET(SELECT *
FROM KU$_COLUMN_VIEW C
WHERE C.OBJ_NUM = V.OBJ#
AND (BITAND(V.PROPERTY
, 1)=1) ORDER BY C.INTCOL_NUM ) AS KU$_COLUMN_LIST_T )
, TV.TYPEOWNER
, TV.TYPENAME
, TV.TYPETEXTLENGTH
, TV.TYPETEXT
, TV.OIDTEXTLENGTH
, TV.OIDTEXT
, TV.TRANSTEXTLENGTH
, SYS.DBMS_METADATA_UTIL.LONG2VARCHAR(TV.TRANSTEXTLENGTH
, 'SYS.TYPED_VIEW$'
, 'TRANSTEXT'
, TV.ROWID)
, TV.UNDERTEXTLENGTH
, SYS.DBMS_METADATA_UTIL.LONG2VARCHAR(TV.UNDERTEXTLENGTH
, 'SYS.TYPED_VIEW$'
, 'UNDERTEXT'
, TV.ROWID)
, CAST( MULTISET(SELECT *
FROM KU$_CONSTRAINT1_VIEW CON
WHERE CON.OBJ_NUM = V.OBJ# ) AS KU$_CONSTRAINT1_LIST_T )
, CAST( MULTISET(SELECT *
FROM KU$_CONSTRAINT2_VIEW CON
WHERE CON.OBJ_NUM = V.OBJ# ) AS KU$_CONSTRAINT2_LIST_T )
FROM SYS.KU$_EDITION_SCHEMAOBJ_VIEW O
, SYS.OBJ$ OO
, SYS.VIEW$ V
, SYS.TYPED_VIEW$ TV
WHERE OO.OBJ# = O.OBJ_NUM
AND OO.OBJ# = V.OBJ#
AND OO.OBJ# = TV.OBJ# (+)
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER_NUM
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))