DBA Data[Home] [Help]

VIEW: SYS.DBMSHSXP_SQL_PROFILE_ATTR

Source

View Text - Preformatted

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