VIEW: CTXSYS.CTX_USER_EXTRACT_POLICIES

Source

View Text - Preformatted

select
  i.idx_name epl_name
  from dr$index i
  where INSTR(i.idx_option, 'E') > 0
    and i.idx_owner# = userenv('SCHEMAID')

View Text - HTML Formatted

SELECT I.IDX_NAME EPL_NAME
FROM DR$INDEX I
WHERE INSTR(I.IDX_OPTION
, 'E') > 0
AND I.IDX_OWNER# = USERENV('SCHEMAID')