select /*+ ORDERED */
idx_name isl_index_name,
substr(dri_sublxv_lang(ixv_value),1,30) isl_language,
substr(substr(ixv_value,instr(ixv_value,':',-1)+1),1,30) isl_alt_value,
substr(substr(ixv_value,instr(ixv_value,':')+1,
instr(ixv_value, ':', -1) - instr(ixv_value,':') - 1),
1,30) isl_object
from dr$index,
dr$index_value
where ixv_oat_id = 60601
and idx_id = ixv_idx_id
and idx_owner# = userenv('SCHEMAID')
SELECT /*+ ORDERED */
IDX_NAME ISL_INDEX_NAME
,
SUBSTR(DRI_SUBLXV_LANG(IXV_VALUE)
, 1
, 30) ISL_LANGUAGE
,
SUBSTR(SUBSTR(IXV_VALUE
, INSTR(IXV_VALUE
, ':'
, -1)+1)
, 1
, 30) ISL_ALT_VALUE
,
SUBSTR(SUBSTR(IXV_VALUE
, INSTR(IXV_VALUE
, ':')+1
,
INSTR(IXV_VALUE
, ':'
, -1) - INSTR(IXV_VALUE
, ':') - 1)
,
1
, 30) ISL_OBJECT
FROM DR$INDEX
,
DR$INDEX_VALUE
WHERE IXV_OAT_ID = 60601
AND IDX_ID = IXV_IDX_ID
AND IDX_OWNER# = USERENV('SCHEMAID')
|
|
|