select '1','0',
null, null, null,
p.package, p.schema,
p.level#, p.class, pr.prepost,
null, null, null, null, null, null, null
FROM sys.exppkgact$ p , ku$_prepost_view pr
where p.class =5
order by p.level#
SELECT '1'
, '0'
,
NULL
, NULL
, NULL
,
P.PACKAGE
, P.SCHEMA
,
P.LEVEL#
, P.CLASS
, PR.PREPOST
,
NULL
, NULL
, NULL
, NULL
, NULL
, NULL
, NULL
FROM SYS.EXPPKGACT$ P
, KU$_PREPOST_VIEW PR
WHERE P.CLASS =5
ORDER BY P.LEVEL#
|
|
|