Re: Describing a Trigger

From: M. Armaghan Saqib <armaghan_at_yahoo.com>
Date: Tue, 08 Feb 2000 08:02:57 GMT
Message-ID: <87oijg$1rj$1@nnrp1.deja.com>

SQL*Plus does not directly support any command to display the trigger (and other objects source code). You must know the data dictionary tables to extract this source code.

My SQL PlusPlus (freeware) makes it extremely easy by simple commands like GETTRG (get trigger source code), GETPKS (get package specifications) etc.

regards,
M. Armaghan Saqib

+---------------------------------------------------------------
| 1. SQL PlusPlus => Add power to SQL Plus command line
| 2. SQL Link for XL => Integrate Oracle with XL

| 3. Oracle CBT with sample GL Accounting System | Download free: http://www.geocities.com/armaghan/

+---------------------------------------------------------------

In article <56In4.8006$_d.618870_at_news1.gvcl1.bc.home.com>,   "Tim" <timfrith_at_nospam.home.com> wrote:
> Thanks, but the sys.dba_source table doesn't have any triggers in it
at all.
>
> "Kenneth C Stahl" <BlueSax_at_Unforgetable.com> wrote in message
> news:389F330A.906C8962_at_Unforgetable.com...
> > Tim wrote:
> > >
> > > Stupid SQL Plus question:
> > >
> > > What is the command to show me the code of a trigger using SQL
Plus?
> > >
> > > Tim
> >
> > set long 5000;
> > select text from sys.dba_source where name = 'procname';

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Tue Feb 08 2000 - 02:02:57 CST