Re: Listing all Stored Procedure in database

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