SELECT
so.name, so.category, so.signature, st.sql_text,
ad.created, ad.last_modified, ad.description,
DECODE(ad.origin, 1, 'MANUAL', 2, 'AUTO', 'UNKNOWN'),
DECODE(BITAND(so.flags, 1), 1, 'ENABLED', 'DISABLED'),
DECODE(BITAND(sq.flags, 1), 1, 'YES', 'NO'),
ad.task_id, ad.task_exec_name, ad.task_obj_id, ad.task_fnd_id,
ad.task_rec_id, ad.task_con_dbid
FROM
sqlobj$ so,
sqlobj$auxdata ad,
sql$text st,
sql$ sq
WHERE
so.signature = st.signature AND
so.signature = ad.signature AND
so.category = ad.category AND
so.signature = sq.signature AND
so.obj_type = 1 AND
ad.obj_type = 1
SELECT
SO.NAME
, SO.CATEGORY
, SO.SIGNATURE
, ST.SQL_TEXT
,
AD.CREATED
, AD.LAST_MODIFIED
, AD.DESCRIPTION
,
DECODE(AD.ORIGIN
, 1
, 'MANUAL'
, 2
, 'AUTO'
, 'UNKNOWN')
,
DECODE(BITAND(SO.FLAGS
, 1)
, 1
, 'ENABLED'
, 'DISABLED')
,
DECODE(BITAND(SQ.FLAGS
, 1)
, 1
, 'YES'
, 'NO')
,
AD.TASK_ID
, AD.TASK_EXEC_NAME
, AD.TASK_OBJ_ID
, AD.TASK_FND_ID
,
AD.TASK_REC_ID
, AD.TASK_CON_DBID
FROM
SQLOBJ$ SO
,
SQLOBJ$AUXDATA AD
,
SQL$TEXT ST
,
SQL$ SQ
WHERE
SO.SIGNATURE = ST.SIGNATURE AND
SO.SIGNATURE = AD.SIGNATURE AND
SO.CATEGORY = AD.CATEGORY AND
SO.SIGNATURE = SQ.SIGNATURE AND
SO.OBJ_TYPE = 1 AND
AD.OBJ_TYPE = 1
|
|
|