DBA Data[Home] [Help]

VIEW: SYS.KU$_XSOBJ_VIEW

Source

View Text - Preformatted

select '1','0',
          o.name,
          o.ws,
          o.owner,
          o.tenant,
          o.id,
          o.type,
          o.status,
          o.flags,
          o.early_dep_cnt,
          o.late_dep_cnt,
          o.aclid,
          (select value(p) from ku$_xsprin_view  p where p.prin_id=o.id)
  from xs$obj o
View Text - HTML Formatted

SELECT '1'
, '0'
, O.NAME
, O.WS
, O.OWNER
, O.TENANT
, O.ID
, O.TYPE
, O.STATUS
, O.FLAGS
, O.EARLY_DEP_CNT
, O.LATE_DEP_CNT
, O.ACLID
, (SELECT VALUE(P)
FROM KU$_XSPRIN_VIEW P
WHERE P.PRIN_ID=O.ID)
FROM XS$OBJ O