select type_id,
type_name,
partition_value,
category_id,
structure_bitmask,
structure_value,
max_code_bytelen
from MGD_IDENCODING_type_tab
where owner = 'MGDSYS' or
owner = sys_context('userenv', 'SESSION_USER')
SELECT TYPE_ID
,
TYPE_NAME
,
PARTITION_VALUE
,
CATEGORY_ID
,
STRUCTURE_BITMASK
,
STRUCTURE_VALUE
,
MAX_CODE_BYTELEN
FROM MGD_IDENCODING_TYPE_TAB
WHERE OWNER = 'MGDSYS' OR
OWNER = SYS_CONTEXT('USERENV'
, 'SESSION_USER')
|
|
|