Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie question : Is there a way to list stored procedures or triggers?
Have a look at user_source and all_source.
Andy
"FSP" <robertfoo_at_pacific.net.sg> wrote in message
news:9qma0l$hto$1_at_newton.pacific.net.sg...
> Hi all, don't know if this is a stupid question. Is there a way to list
all
> stored procedures or triggers in a database, or to search for a procedure.
> And the procedure's or trigger's body can be displayed as well ?
> Thanks a lot.
>
>
Received on Thu Oct 18 2001 - 05:47:12 CDT