select 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$ u2
where p2.pre_owner# = u2.user#
and p1.pre_owner# = userenv('SCHEMAID')
and slx_sub_pre_id = p2.pre_id
and slx_pre_id = p1.pre_id
SELECT 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$ U2
WHERE P2.PRE_OWNER# = U2.USER#
AND P1.PRE_OWNER# = USERENV('SCHEMAID')
AND SLX_SUB_PRE_ID = P2.PRE_ID
AND SLX_PRE_ID = P1.PRE_ID
|
|
|