Re: How to retreive source code for trigger?

From: <steveee_ca_at_my-deja.com>
Date: Thu, 04 Jan 2001 18:26:11 GMT
Message-ID: <932f7m$n3s$1@nnrp1.deja.com>

Hi,

First look at the DBA_TRIGGERS view..see if the 'trigger body' column has what you need...

Steve

In article <932ein$mel$1_at_nnrp1.deja.com>, twoplustwo_at_my-deja.com wrote:
> I would like to retreive all the trigger names and the "create
> trigger ... ' source code from the database. Has anyone written code
to
> retreive this type of information?
>
> Thanks
>
> TwoPlusTwo
>
> Sent via Deja.com
> http://www.deja.com/
>

Sent via Deja.com
http://www.deja.com/ Received on Thu Jan 04 2001 - 12:26:11 CST

This message: [ Message body ]
Next message: Paul Bennett: "dbstart script failure on 8i"
Previous message: twoplustwo_at_my-deja.com: "How to retreive source code for trigger?"
In reply to: twoplustwo_at_my-deja.com: "How to retreive source code for trigger?"
Next in thread: Steven Hauser: "Re: How to retreive source code for trigger?"
Reply: Steven Hauser: "Re: How to retreive source code for trigger?"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

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