Re: Trigger question

From: <DBarbour_at_austin.isd.tenet.edu>
Date: Thu, 28 Mar 2002 05:19:04 -0800
Message-ID: <F001.00435D75.20020328051904@fatcity.com>

Oh my! (Is that gentle enough Jared?)

 

Roland,

 

I admire your ability to participate in this forum using the English language, I certainly could not pose questions within a Swedish discussion group.  Since you have the ability to use the language, might I suggest once again you subscribe at http://otn.oracle.com  (do they have a Swedish version as well?), then type the word  'trigger' into the search box.  

 

Triggers are a wonderful, varied construct and all their glory (including samples of just the type you wish to create) will be revealed.

 

Just a thought.  No offense.

 

David A. Barbour
Oracle DBA, OCP
AISD
512-414-1002

 
Roland.Skoldblom@ica.se
Sent by: root@fatcity.com
03/28/2002 03:33 AM PST
Please respond to ORACLE-L

To: Multiple recipients of list ORACLE-L <ORACLE-L@fatcity.com>
cc:
bcc:
Subject: Trigger question

Hallo,

anyone who can please helpme with a trigger script that does the following:

I want  this script to run when I have updated a field in a table.

update test set namn = upper(substr(namn,1,1) || substr(namn),2)

I want this trigger to fire only for the selected record(row), that is going to be updated. Please help me with this, it might seem simple but I cant get it right.

Thanks in advance

Roland S

--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author:
 INET: Roland.Skoldblom@ica.se

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@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).

-- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: INET: DBarbour@austin.isd.tenet.edu 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@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). Received on Thu Mar 28 2002 - 07:19:04 CST