DBA Data[Home] [Help]

VIEW: CTXSYS.DRV$DELETE2

Source

View Text - Preformatted

select "DEL_IDX_ID","DEL_IXP_ID","DEL_DOCID" from dr$delete
where del_idx_id = SYS_CONTEXT('DR$APPCTX','IDXID')
with check option
View Text - HTML Formatted

SELECT "DEL_IDX_ID"
, "DEL_IXP_ID"
, "DEL_DOCID"
FROM DR$DELETE WHERE DEL_IDX_ID = SYS_CONTEXT('DR$APPCTX'
, 'IDXID') WITH CHECK OPTION