VIEW: CTXSYS.CTX_SUB_LEXERS

Source

View Text - Preformatted

select  u1.name            slx_owner
       ,p1.pre_name        slx_name
       ,slx_language       slx_language
       ,slx_alt_value      slx_alt_value
       ,u2.name            slx_sub_owner
       ,p2.pre_name        slx_sub_name
       ,slx_lang_dependent slx_lang_dependent
from   dr$sub_lexer
      ,dr$preference p1
      ,dr$preference p2
      ,sys.user$ u1
      ,sys.user$ u2
where p2.pre_owner# = u2.user#
  and p1.pre_owner# = u1.user#
  and slx_sub_pre_id = p2.pre_id
  and slx_pre_id = p1.pre_id

View Text - HTML Formatted

SELECT U1.NAME SLX_OWNER
, P1.PRE_NAME SLX_NAME
, SLX_LANGUAGE SLX_LANGUAGE
, SLX_ALT_VALUE SLX_ALT_VALUE
, U2.NAME SLX_SUB_OWNER
, P2.PRE_NAME SLX_SUB_NAME
, SLX_LANG_DEPENDENT SLX_LANG_DEPENDENT FROM DR$SUB_LEXER
, DR$PREFERENCE P1
, DR$PREFERENCE P2
, SYS.USER$ U1
, SYS.USER$ U2 WHERE P2.PRE_OWNER# = U2.USER#
AND P1.PRE_OWNER# = U1.USER#
AND SLX_SUB_PRE_ID = P2.PRE_ID
AND SLX_PRE_ID = P1.PRE_ID