VIEW: XDB.DOCUMENT_LINKS

Source

View Text - Preformatted

SELECT
dl.source_id,
dl.target_id,
dl.target_path,
decode(bitand(sys_op_rawtonum(dl.flags),1),1, 'Weak',
       decode(bitand(sys_op_rawtonum(dl.flags),2),2,'Symbolic','Hard')),
decode(bitand(sys_op_rawtonum(dl.flags),4),4, 'XInclude', 'XLink'),
decode(bitand(sys_op_rawtonum(dl.flags),8),8, 'Resource Metadata',
       'Resource Content')
from xdb.xdb$d_link dl, xdb.xdb$resource r
where dl.source_id = r.object_id
and sys_checkacl(r.xmldata.acloid, r.xmldata.ownerid,
xmltype('
      
      
 ')) = 1

View Text - HTML Formatted

SELECT DL.SOURCE_ID
, DL.TARGET_ID
, DL.TARGET_PATH
, DECODE(BITAND(SYS_OP_RAWTONUM(DL.FLAGS)
, 1)
, 1
, 'WEAK'
, DECODE(BITAND(SYS_OP_RAWTONUM(DL.FLAGS)
, 2)
, 2
, 'SYMBOLIC'
, 'HARD'))
, DECODE(BITAND(SYS_OP_RAWTONUM(DL.FLAGS)
, 4)
, 4
, 'XINCLUDE'
, 'XLINK')
, DECODE(BITAND(SYS_OP_RAWTONUM(DL.FLAGS)
, 8)
, 8
, 'RESOURCE METADATA'
, 'RESOURCE CONTENT') FROM XDB.XDB$D_LINK DL
, XDB.XDB$RESOURCE R WHERE DL.SOURCE_ID = R.OBJECT_ID AND SYS_CHECKACL(R.XMLDATA.ACLOID
, R.XMLDATA.OWNERID
, XMLTYPE(' ')) = 1