Oracle-L: Re: Trigger question

From: Igor Neyman <ineyman_at_perceptron.com>
Date: Thu, 28 Mar 2002 05:48:34 -0800
Message-ID: <F001.00435DC6.20020328054834@fatcity.com>

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_at_perceptron.com

Original Message ----- From: DBarbour_at_austin.isd.tenet.edu To: Multiple recipients of list ORACLE-L 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.

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_at_ica.se
  Sent by: root_at_fatcity.com
  03/28/2002 03:33 AM PST
  Please respond to ORACLE-L

  To: Multiple recipients of list ORACLE-L <ORACLE-L_at_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_at_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_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).

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

--

Please see the official ORACLE-L FAQ: http://www.orafaq.com
--

Author: Igor Neyman
INET: ineyman_at_perceptron.com

Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051
San Diego, California        -- Public Internet access / Mailing Lists
--------------------------------------------------------------------