VIEW: CTXSYS.CTX_USER_EXTRACT_RULES

Source

View Text - Preformatted

select
  i.idx_name erl_policy_name,
  e.erl_rule_id erl_rule_id,
  e.erl_language erl_language,
  e.erl_rule erl_rule,
  e.erl_modifier erl_modifier,
  e.erl_type erl_type,
  decode(e.erl_status,
         0,'not compiled',
         1, 'to be deleted',
         2, 'compiled') erl_status,
  e.erl_comments erl_comments
  from dr$user_extract_rule e, dr$index i
where i.idx_owner# = userenv('SCHEMAID')
  and e.erl_pol_id = i.idx_id

View Text - HTML Formatted

SELECT I.IDX_NAME ERL_POLICY_NAME
, E.ERL_RULE_ID ERL_RULE_ID
, E.ERL_LANGUAGE ERL_LANGUAGE
, E.ERL_RULE ERL_RULE
, E.ERL_MODIFIER ERL_MODIFIER
, E.ERL_TYPE ERL_TYPE
, DECODE(E.ERL_STATUS
, 0
, 'NOT COMPILED'
, 1
, 'TO BE DELETED'
, 2
, 'COMPILED') ERL_STATUS
, E.ERL_COMMENTS ERL_COMMENTS
FROM DR$USER_EXTRACT_RULE E
, DR$INDEX I WHERE I.IDX_OWNER# = USERENV('SCHEMAID')
AND E.ERL_POL_ID = I.IDX_ID