VIEW: SYS.KU$_10_2_STRMTABLE_VIEW

Source

View Text - Preformatted

select '1','0',
         (select dbms_metadata_util.get_vers_dpapi from dual),
         (select dbms_metadata_util.get_endianness from dual),
         (select value from v$nls_parameters
                 where parameter='NLS_CHARACTERSET'),
         (select value from v$nls_parameters
                 where parameter='NLS_NCHAR_CHARACTERSET'),
         (select dbtimezone from dual),
         (select utl_xml.getfdo from dual),
         t.obj#,
         o.owner_name, o.name, o.subname,
         t.property,
         cast( multiset(select * from ku$_10_2_strmcol_view c
                        where c.obj_num = t.obj#
                        and bitand(c.property,32768)=0  -- unused column
                        -- 10.2 view does not have base_col_type
                        -- and c.base_col_type<2
                        order by c.segcol_num
                        ) as ku$_10_2_strmcol_list_t
              )
  from  ku$_schemaobj_view o, tab$ t
  where t.obj# = o.obj_num
        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'
, '0'
, (SELECT DBMS_METADATA_UTIL.GET_VERS_DPAPI
FROM DUAL)
, (SELECT DBMS_METADATA_UTIL.GET_ENDIANNESS
FROM DUAL)
, (SELECT VALUE
FROM V$NLS_PARAMETERS
WHERE PARAMETER='NLS_CHARACTERSET')
, (SELECT VALUE
FROM V$NLS_PARAMETERS
WHERE PARAMETER='NLS_NCHAR_CHARACTERSET')
, (SELECT DBTIMEZONE
FROM DUAL)
, (SELECT UTL_XML.GETFDO
FROM DUAL)
, T.OBJ#
, O.OWNER_NAME
, O.NAME
, O.SUBNAME
, T.PROPERTY
, CAST( MULTISET(SELECT *
FROM KU$_10_2_STRMCOL_VIEW C
WHERE C.OBJ_NUM = T.OBJ#
AND BITAND(C.PROPERTY
, 32768)=0 -- UNUSED COLUMN -- 10.2 VIEW DOES NOT HAVE BASE_COL_TYPE --
AND C.BASE_COL_TYPE<2 ORDER BY C.SEGCOL_NUM ) AS KU$_10_2_STRMCOL_LIST_T )
FROM KU$_SCHEMAOBJ_VIEW O
, TAB$ T
WHERE T.OBJ# = O.OBJ_NUM
AND (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID') IN (O.OWNER_NUM
, 0) OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))