Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Listing all Stored Procedure in database
-- "Daniel Morgan" <damorgan_at_exxesolutions.com> wrote in message news:3F123EE9.AB379B84_at_exxesolutions.com...Received on Mon Jul 14 2003 - 05:14:11 CDT
> Burton Peltier wrote:
>
> > That's asking for a lot... every procedure (what about Plsql packages
and
> > functions?).
> >
> > You will need to write some code (amount depends on how good you want
the
> > list to look).
> >
> > Or, buy some tool that can do this. We use TOAD from quest and it has an
> > option to generate Html output of any select-able objects. With a few
clicks
> > you could do this with TOAD .
> >
> > --
> > "Egbon" <vicnjowusi_at_hotmail.com> wrote in message
> > news:372e7dae.0307110827.585d7be1_at_posting.google.com...
> > > Hi,
> > >
> > > What command can I use to list all the Stored Procedures in Oracle
> > > database. I am new to Oracle.
> > >
> > > Thanks.
> > >
> > > Egbon
>
> It is easy ...
>
> SELECT name FROM source$;
>
> Just getting procedures merely requires:
>
> SELECT object_name
> FROM dba_objects
> WHERE object_type = 'PROCEDURE';
>
> Now extracting the code ... that's an entirely different animal.
I agree, and TOAD does this and shows relationships and anything else in the schema - just click it off from a list. I have Sqlplus scripts from way back that I use to use all the time for stuff like this. But, I don't use them much lately.
>
> --
> Daniel Morgan
> http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
> damorgan_at_x.washington.edu
> (replace 'x' with a 'u' to reply)
>
>