how 2 know all packages (oracle)

select rownum NO, OBJECT_NAME
from
(
select distinct OBJECT_NAME from all_procedures
where owner=’DBADMIN’
order by OBJECT_NAME
)

Leave a Reply