select /*+ ORDERED */
u.name isl_index_owner,
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,
sys.user$ u,
dr$index_value
where ixv_oat_id = 60601
and idx_id = ixv_idx_id
and idx_owner# = u.user#
SELECT /*+ ORDERED */
U.NAME ISL_INDEX_OWNER
,
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
,
SYS.USER$ U
,
DR$INDEX_VALUE
WHERE IXV_OAT_ID = 60601
AND IDX_ID = IXV_IDX_ID
AND IDX_OWNER# = U.USER#
|
|
|