Re: Newbie question : Is there a way to list stored procedures or triggers?

"Andrew Hardy" <nobody_at_spam.from.news.AdvanticaTech.com> wrote in message news:<9qmbvh$2q7$1_at_sun-cc204.lut.ac.uk>...
> 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.
> >

FSP, as being new to Oracle you may benefit from the short article on the Oracle rdbms dictionsary available at the cooperative FAQ.

How do I find information about a database object (table, index, constraint etc.) available at:
http://www.jlcomp.demon.co.uk/faq/object_info.html

• Mark D Powell --