VIEW: CTXSYS.DRV$USER_EXTRACT_RULE

Source

View Text - Preformatted

select "ERL_POL_ID","ERL_RULE_ID","ERL_LANGUAGE","ERL_RULE","ERL_MODIFIER","ERL_TYPE","ERL_STATUS","ERL_COMMENTS" from dr$user_extract_rule
where erl_pol_id = SYS_CONTEXT('DR$APPCTX', 'IDXID')
with check option

View Text - HTML Formatted

SELECT "ERL_POL_ID"
, "ERL_RULE_ID"
, "ERL_LANGUAGE"
, "ERL_RULE"
, "ERL_MODIFIER"
, "ERL_TYPE"
, "ERL_STATUS"
, "ERL_COMMENTS"
FROM DR$USER_EXTRACT_RULE WHERE ERL_POL_ID = SYS_CONTEXT('DR$APPCTX'
, 'IDXID') WITH CHECK OPTION