| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> Re: Trigger re-engineering
This is a multi-part message in MIME format.
--------------8DEE21C775F0C583CEB285AD Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit
Jim,
Thanks very much for the response, been on a course, hence the delayed reply. Actually wrote my own rev-eng script. Am stuck (if you can call it that) w/a SUN Ultra-10 workstation as my desktop. It has a huge amount of memory and is a fantastic box to run on, however - it don't run NT. We have Citrix, but getting software setup is a pain as I have to involve the NT guys who are just as busy as me. The end product is that to date we've not pursued any of the NT software, such as toad. Last week I sequestered an NT box and the other DBA and I are now sharing it with the explicit purpose being getting things like toad setup. If ya want to have a look at my code, just let me know! :-)
Cheers,
Casey ...
"HAWKINS, JAMES W [FND/1000]" wrote:
> 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
>
> ______________________________________
> Jim Hawkins
> Oracle Database Administration Team
> Monsanto Company
> 800 North Lindbergh - G3ED
> St. Louis, MO 63167
> 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-----
> Sent: Thursday, May 11, 2000 5:25 AM
> To: Multiple recipients of list ORACLE-L
>
> 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 ...
>
> TIA,
>
> Casey ...
> --
> Author: HAWKINS, JAMES W [FND/1000]
> INET: JAMES.W.HAWKINS_at_stl.Monsanto.com
>
> Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051
> San Diego, California -- Public Internet access / Mailing Lists
> --------------------------------------------------------------------
> To REMOVE yourself from this mailing list, send an E-Mail message
> to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
> the message BODY, include a line containing: UNSUB ORACLE-L
> (or the name of mailing list you want to be removed from). You may
> also send the HELP command for other information (like subscribing).
--------------8DEE21C775F0C583CEB285AD
Content-Type: text/x-vcard; charset=us-ascii;
name="cdyke.vcf"
Content-Transfer-Encoding: 7bit Content-Description: Card for Casey Dyke Content-Disposition: attachment;
begin:vcard
n:Dyke;Casey
tel;pager:(022) 9436 9290 tel;home:61 2 9948 1487 tel;work:61 2 9005 1021
url:www.realsurf.com org:At Home Network Australia;IT-Ops adr:;;100 Harris Street;Pyrmont;NSW;2042;Australiaversion:2.1
 |
 |