DBA Data[Home] [Help]

VIEW: SYS.KU$_END_PLUGTS_BLK_VIEW

Source

View Text - Preformatted

select '1','0',
  1,
  (select sys.dbms_metadata.get_plugts_blk(1) from dual)
  from sys.dual
  where (SYS_CONTEXT('USERENV','CURRENT_USERID')=0
                 OR EXISTS ( SELECT * FROM sys.session_roles
                    WHERE role='SELECT_CATALOG_ROLE' ))
View Text - HTML Formatted

SELECT '1'
, '0'
, 1
, (SELECT SYS.DBMS_METADATA.GET_PLUGTS_BLK(1)
FROM DUAL)
FROM SYS.DUAL
WHERE (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID')=0 OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))