DBA Data[Home] [Help]

VIEW: CTXSYS.DRV$PENDING

Source

View Text - Preformatted

select "PND_CID","PND_PID","PND_ROWID","PND_TIMESTAMP","PND_LOCK_FAILED" from dr$pending
 where pnd_cid = SYS_CONTEXT('DR$APPCTX','IDXID')
with check option
View Text - HTML Formatted

SELECT "PND_CID"
, "PND_PID"
, "PND_ROWID"
, "PND_TIMESTAMP"
, "PND_LOCK_FAILED"
FROM DR$PENDING
WHERE PND_CID = SYS_CONTEXT('DR$APPCTX'
, 'IDXID') WITH CHECK OPTION