select so.name, od.comp_data
from sqlobj$ so,
sqlobj$data od
where so.signature = od.signature and
so.category = od.category and
so.obj_type = 1 and
od.obj_type = 1
View Text - HTML Formatted
SELECT SO.NAME , OD.COMP_DATA
FROM SQLOBJ$ SO ,
SQLOBJ$DATA OD
WHERE SO.SIGNATURE = OD.SIGNATURE AND
SO.CATEGORY = OD.CATEGORY AND
SO.OBJ_TYPE = 1 AND
OD.OBJ_TYPE = 1