Re: Trigger Script Generation

From: M. Armaghan Saqib <armaghan_at_yahoo.com>
Date: Wed, 19 Jan 2000 09:34:00 GMT
Message-ID: <8640e8$p2k$1@nnrp1.deja.com>

Use my freeware SQLPlusPlus

SQL> EXEC S.GETTRG('TABLE_NAME') will dump out all triggers for the TABLE_NAME given.

regards,
M. Aramghan Saqib

SQL PlusPlus: Add power to SQL Plus.
SQL Link for XL: Integrate Oracle with XL.
Oracle CBT with sample GL (Triggers and Forms Source Code included. Download free: http://www.geocities.com/armaghan/

In article <dexe4.19171$lv5.75531_at_news-server.bigpond.net.au>, "Jim Katsos" <jkatsos_at_oz.quests.com> wrote:
> Does anyone have some pl/sql which generates trigger ddl from the
> dba_triggers view.
>
> --
> Jim Katsos
> Quest Software Pty Ltd
> http://www.quests.com
> tel +61 3 9811 8068
> mob 0411088578

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Jan 19 2000 - 03:34:00 CST