select
u.name sec_owner,
sgp_name sec_section_group,
decode(sec_type, 1, 'ZONE', 2, 'FIELD', 3, 'SPECIAL', 4, 'STOP',
5, 'ATTR', 7, 'MDATA', 8, 'COLUMN SDATA',
9, 'COLUMN MDATA', 10, 'SDATA', null)
sec_type,
sec_id sec_id,
decode(sec_type, 4, null, sec_name)
sec_name,
sec_tag sec_tag,
sec_visible sec_visible,
decode(sec_datatype, 2, 'NUMBER', 5, 'VARCHAR2', 12, 'DATE', 23, 'RAW',
null)
sec_datatype
from dr$section sec, dr$section_group sgp, sys.user$ u
where sgp.sgp_id = sec.sec_sgp_id
and sgp_owner# = u.user#
SELECT
U.NAME SEC_OWNER
,
SGP_NAME SEC_SECTION_GROUP
,
DECODE(SEC_TYPE
, 1
, 'ZONE'
, 2
, 'FIELD'
, 3
, 'SPECIAL'
, 4
, 'STOP'
,
5
, 'ATTR'
, 7
, 'MDATA'
, 8
, 'COLUMN SDATA'
,
9
, 'COLUMN MDATA'
, 10
, 'SDATA'
, NULL)
SEC_TYPE
,
SEC_ID SEC_ID
,
DECODE(SEC_TYPE
, 4
, NULL
, SEC_NAME)
SEC_NAME
,
SEC_TAG SEC_TAG
,
SEC_VISIBLE SEC_VISIBLE
,
DECODE(SEC_DATATYPE
, 2
, 'NUMBER'
, 5
, 'VARCHAR2'
, 12
, 'DATE'
, 23
, 'RAW'
,
NULL)
SEC_DATATYPE
FROM DR$SECTION SEC
, DR$SECTION_GROUP SGP
, SYS.USER$ U
WHERE SGP.SGP_ID = SEC.SEC_SGP_ID
AND SGP_OWNER# = U.USER#
|
|
|