Re: Query for functions and procedures in Package

Stephen Lappin <SL_at_RTEL.co.uk> wrote:

>Is there dictionary view available that can be queried to show what
>procedures and functions are contained within a Pl/SQL Package?
>
>Slainte mhath
>Stephen Lappin
>
>

all_source, dba_source, user_source

select owner,name,type,text from all_source order by owner,name,type,line;

HTH

--
Ludo Joris
RUCA - University of Antwerp, Belgium
lujo_at_ruca.ua.ac.be