Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Trigger re-engineering
Casey,
I would suggest going to www.toadsoft.com and downloading the freeware
version of TOAD. It's a life-saver for things like this, and as far as I'm
concerned, a must for every DBA. Open the schema browser, select the
"Triggers" tab for the desired schema, then select the "Proc Edit Window"
icon and there you go.
I'm lazy too...
Jim
314.694.7592 - Office 314.308.6614 - Cellular 314.294.2623 - Pager james.w.hawkins_at_monsanto.com
"Far better it is to dare mighty things, to win glorious triumphs, even
though checkered by failure, than to take rank with those poor spirits
who neither enjoy much nor suffer much, because they live in the gray
twilight that knows neither victory nor defeat."
--Theodore Roosevelt
-----Original Message-----
From: Casey Dyke [mailto:cdyke_at_homenetwork.com.au]
Sent: Thursday, May 11, 2000 5:25 AM
To: Multiple recipients of list ORACLE-L
Subject: Trigger re-engineering
Folks,
Being lazy here as I could do it myself, but I just realised I need to do this and as I don't have a script handy, not farting around w/it in the morning would be handy. Just need to rev-eng some triggers out of the dd. Had a look (8.0.5) and the trigger_type and triggering_event don't seem to give me what I want syntactically. Looks like I get 'BEFORE EACH ROW' from type and 'INSERT' from triggering_event.
Guess I need syntax like 'create or replace ... before insert on <table_name> for each row'. In my naiveity, I thought the columns would front the info up and I could whip through it easy. Looks to be a little more tricky, unless I'm not looking at the whole picture. Seems odd to me, but I've had quite a long day ... Received on Fri May 12 2000 - 08:35:38 CDT
![]() |
![]() |