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

Home -> Community -> Usenet -> c.d.o.misc -> Re: Newbie question : Is there a way to list stored procedures or triggers?

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

From: Scott Mattes <ScottMattes_at_yahoo.com>
Date: Thu, 18 Oct 2001 16:50:29 GMT
Message-ID: <pLDz7.746$vK6.332447@news1.news.adelphia.net>


A very nice tool for poking around the DB while you learn the ins and outs is TOAD, from www.toadsoft.com. There is a free version and a good place to start is to look under the Database menu entry and the scheme item.

"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 - 11:50:29 CDT

Original text of this message

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