VIEW: CTXSYS.CTX_USER_SECTIONS

Source

View Text - Preformatted

select
   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
where sgp.sgp_id = sec.sec_sgp_id
  and sgp_owner# = userenv('SCHEMAID')

View Text - HTML Formatted

SELECT 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 WHERE SGP.SGP_ID = SEC.SEC_SGP_ID
AND SGP_OWNER# = USERENV('SCHEMAID')