Return-Path: Received: from newsfeed.cts.com (newsfeed.cts.com [209.68.248.164]) by naude.co.za (8.11.2/8.11.2) with SMTP id g2SE3iO28464 for ; Thu, 28 Mar 2002 09:03:44 -0500 Received: from fatcity.UUCP (uucp@localhost) by newsfeed.cts.com (8.9.3/8.9.3) with UUCP id GAA86562; Thu, 28 Mar 2002 06:05:14 -0800 (PST) Received: by fatcity.com (26-Feb-2001/v1.0g-b70/bab) via UUCP id 00435DC6; Thu, 28 Mar 2002 05:48:34 -0800 Message-ID: Date: Thu, 28 Mar 2002 05:48:34 -0800 To: Multiple recipients of list ORACLE-L X-Comment: Oracle RDBMS Community Forum X-Sender: "Igor Neyman" Sender: root@fatcity.com Reply-To: ORACLE-L@fatcity.com Errors-To: ML-ERRORS@fatcity.com From: "Igor Neyman" Subject: Re: Trigger question Organization: Fat City Network Services, San Diego, California X-ListServer: v1.0g, build 70; ListGuru (c) 1996-2001 Bruce A. Bergman Precedence: bulk Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0033_01C1D636.5F2A4BB0" ------=_NextPart_000_0033_01C1D636.5F2A4BB0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable Roland (and those, who thinks, that RTFM is not such a good advice), When you are saying, that you "can't get the trigger right", please be = more specific: post trigger code, that you wrote, post errors, that you are getting, or = if there is no errors, tell, what your trigger does not do, that you = want it to do. If you don't post all these "little" things, you will be getting "RTFM" = advice. Igor Neyman, OCP DBA ineyman@perceptron.com =20 ----- Original Message -----=20 From: DBarbour@austin.isd.tenet.edu=20 To: Multiple recipients of list ORACLE-L=20 Sent: Thursday, March 28, 2002 8:19 AM Subject: Re: Trigger question 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. =20 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 cc:=20 bcc:=20 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 =3D 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). ------=_NextPart_000_0033_01C1D636.5F2A4BB0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
Roland (and those, who thinks, that RTFM is not such = a good=20 advice),
 
When you are saying, that you "can't get the trigger = right",=20 please be more specific:
post trigger code, that you wrote, post errors, that = you are=20 getting, or if there is no errors, tell, what your trigger does not do, = that you=20 want it to do.
If you don't post all these "little" things, you = will be=20 getting "RTFM" advice.
 
Igor Neyman, OCP DBA
ineyman@perceptron.com
&nbs= p;=20
----- Original Message -----
From:=20 DBarbour@austin.isd.tenet.e= du=20
Sent: Thursday, March 28, 2002 = 8:19=20 AM
Subject: Re: Trigger = question

Oh my! (Is that gentle enough Jared?)

 

Roland,

 

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

 

Triggers are a wonderful, varied construct and all their glory = (including=20 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=20 by: root@fatcity.com
03/28/2002 03:33 AM=20 PST
Please respond to = ORACLE-L

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


Hallo,

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

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

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

I want this trigger to fire only for the = selected=20 record(row), that is going to be updated. Please help me with this, it = might=20 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:=20 Roland.Skoldblom@ica.se

Fat City=20 Network Services    -- (858) 538-5051  FAX: (858)=20 538-5051
San Diego, California        -- Public = Internet access / Mailing=20 = Lists
----------------------------------------------------------------= ----
To=20 REMOVE yourself from this mailing list, send an E-Mail message
to:=20 ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in
the = message=20 BODY, include a line containing: UNSUB ORACLE-L
(or the name of = mailing=20 list you want to be removed from).  You may
also send the HELP = command=20 for other information (like subscribing).

-- Please see the = official=20 ORACLE-L FAQ: http://www.orafaq.com -- Author: INET:=20 DBarbour@austin.isd.tenet.edu Fat City Network Services -- (858) = 538-5051 FAX:=20 (858) 538-5051 San Diego, California -- Public Internet access / = Mailing Lists=20 -------------------------------------------------------------------- = To REMOVE=20 yourself from this mailing list, send an E-Mail message to:=20 ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the = message=20 BODY, include a line containing: UNSUB ORACLE-L (or the name of = mailing list=20 you want to be removed from). You may also send the HELP command for = other=20 information (like subscribing). ------=_NextPart_000_0033_01C1D636.5F2A4BB0-- -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Igor Neyman INET: ineyman@perceptron.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@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).