VIEW: CTXSYS.CTX_SECTION_GROUPS

Source

View Text - Preformatted

select
   u.name      sgp_owner,
   sgp_name,
   obj_name    sgp_type
from dr$section_group, dr$object, dr$class, sys.user$ u
where sgp_obj_id = obj_id
  and obj_system = 'N'
  and obj_cla_id = cla_id
  and cla_name = 'SECTION_GROUP'
  and sgp_owner# = u.user#

View Text - HTML Formatted

SELECT U.NAME SGP_OWNER
, SGP_NAME
, OBJ_NAME SGP_TYPE FROM DR$SECTION_GROUP
, DR$OBJECT
, DR$CLASS
, SYS.USER$ U WHERE SGP_OBJ_ID = OBJ_ID
AND OBJ_SYSTEM = 'N'
AND OBJ_CLA_ID = CLA_ID
AND CLA_NAME = 'SECTION_GROUP'
AND SGP_OWNER# = U.USER#