select
sgp_name,
obj_name sgp_type
from dr$section_group, dr$object, dr$class
where sgp_obj_id = obj_id
and obj_system = 'N'
and obj_cla_id = cla_id
and cla_name = 'SECTION_GROUP'
and sgp_owner# = userenv('SCHEMAID')
SELECT
SGP_NAME
,
OBJ_NAME SGP_TYPE
FROM DR$SECTION_GROUP
, DR$OBJECT
, DR$CLASS
WHERE SGP_OBJ_ID = OBJ_ID
AND OBJ_SYSTEM = 'N'
AND OBJ_CLA_ID = CLA_ID
AND CLA_NAME = 'SECTION_GROUP'
AND SGP_OWNER# = USERENV('SCHEMAID')
|
|
|