Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.misc -> Re: PL/SQL: Identifying package in which a procedure or function is found
hoke_at_gse.harvard.edu (Ken Ho) wrote in
news:88f8c6ea.0401210929.5ef65cbb_at_posting.google.com:
> Is there a way to generate the list of all procedures and functions
> which are found in packages, including the "owning" package for each?
>
Yes.
Depending on your release level you can try
select *
from sys.all_arguments
Where owner = ''
And package_name = ''
Received on Wed Jan 21 2004 - 12:10:39 CST
![]() |
![]() |