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
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
|
|
|