Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Listing all Stored Procedure in database
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.
-- 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)Received on Mon Jul 14 2003 - 00:26:01 CDT