VIEW: CTXSYS.DRV$TREE

Source

View Text - Preformatted

select "IDXID","SECID","NODE_SEQ" from ctxsys.dr$tree
where idxid = SYS_CONTEXT('DR$APPCTX', 'IDXID')
with check option

View Text - HTML Formatted

SELECT "IDXID"
, "SECID"
, "NODE_SEQ"
FROM CTXSYS.DR$TREE WHERE IDXID = SYS_CONTEXT('DR$APPCTX'
, 'IDXID') WITH CHECK OPTION