SELECT comp_id,
type_id,
comp_name,
start_bit,
end_bit,
comp_bitmask,
substr_pos,
substr_len,
bits_to_right,
bits_to_left,
comp_alias,
fixed_comp_value,
order_in_code
FROM MGD_IDENCODING_comp_tab
WHERE owner = 'MGDSYS' OR
owner = sys_context('userenv', 'SESSION_USER')
SELECT COMP_ID
,
TYPE_ID
,
COMP_NAME
,
START_BIT
,
END_BIT
,
COMP_BITMASK
,
SUBSTR_POS
,
SUBSTR_LEN
,
BITS_TO_RIGHT
,
BITS_TO_LEFT
,
COMP_ALIAS
,
FIXED_COMP_VALUE
,
ORDER_IN_CODE
FROM MGD_IDENCODING_COMP_TAB
WHERE OWNER = 'MGDSYS' OR
OWNER = SYS_CONTEXT('USERENV'
, 'SESSION_USER')
|
|
|