Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Listing all Stored Procedure in database

Re: Listing all Stored Procedure in database

From: Daniel Morgan <damorgan_at_exxesolutions.com>
Date: Sun, 13 Jul 2003 22:26:01 -0700
Message-ID: <3F123EE9.AB379B84@exxesolutions.com>


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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US