DBA Data[Home] [Help]

VIEW: SYS.KU$_PROCACT_SYS_PKG_VIEW

Source

View Text - Preformatted

select
  p.package pname, p.schema pschema,
  p.level# plevel
  FROM  sys.exppkgact$ p
  where p.class =1
  order by p.level#
View Text - HTML Formatted

SELECT P.PACKAGE PNAME
, P.SCHEMA PSCHEMA
, P.LEVEL# PLEVEL
FROM SYS.EXPPKGACT$ P
WHERE P.CLASS =1 ORDER BY P.LEVEL#