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