VIEW: CTXSYS.CTX_ALEXER_DICTS

Source

View Text - Preformatted

select idx.idx_owner# as ald_owner, b.dict_name as ald_name,
  a.dict_lang as ald_lang
  from DR$IDX_DICTIONARIES a, DR$DICTIONARY b, dr$index idx
  where idx.idx_owner# = b.dict_owner# and a.dict_lang = b.dict_lang

View Text - HTML Formatted

SELECT IDX.IDX_OWNER# AS ALD_OWNER
, B.DICT_NAME AS ALD_NAME
, A.DICT_LANG AS ALD_LANG
FROM DR$IDX_DICTIONARIES A
, DR$DICTIONARY B
, DR$INDEX IDX
WHERE IDX.IDX_OWNER# = B.DICT_OWNER#
AND A.DICT_LANG = B.DICT_LANG