VIEW: SYS.KU$_PLUGTS_BLK_VIEW

Source

View Text - Preformatted

select '1','0',
  pr.prepost,
  (select sys.dbms_metadata.get_plugts_blk(pr.prepost) from dual)
  from ku$_prepost_view pr
  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'
, PR.PREPOST
, (SELECT SYS.DBMS_METADATA.GET_PLUGTS_BLK(PR.PREPOST)
FROM DUAL)
FROM KU$_PREPOST_VIEW PR
WHERE (SYS_CONTEXT('USERENV'
, 'CURRENT_USERID')=0 OR EXISTS ( SELECT *
FROM SYS.SESSION_ROLES
WHERE ROLE='SELECT_CATALOG_ROLE' ))