Re: Describing a Trigger
From: Tim <timfrith_at_nospam.home.com>
Date: Mon, 07 Feb 2000 22:58:09 GMT
Message-ID: <56In4.8006$_d.618870_at_news1.gvcl1.bc.home.com>
Date: Mon, 07 Feb 2000 22:58:09 GMT
Message-ID: <56In4.8006$_d.618870_at_news1.gvcl1.bc.home.com>
[Quoted] Thanks, but the sys.dba_source table doesn't have any triggers in it at all.
[Quoted] "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';
Received on Mon Feb 07 2000 - 23:58:09 CET