Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> NEW / OLD in triiger

NEW / OLD in triiger

From: John Bester <johnb_at_iconnect.co.za>
Date: Wed, 15 Jul 1998 16:06:40 +0200
Message-ID: <35ad3645.0@informer.hixnet.co.za>


Since the oracle documentation does not give any usefull trigger examples, I'm posting this question:

How do I access / change values of rows inserted / modified rows from within a trigger. I am used to the MSSQL syntax, but there are no descent examples (or descriptions) on using NEW an OLD in a trigger. Do I treat them as tables? I seem to get a warning everytime I try to access them.

Any examples will be much appreciated.
---
John Bester
johnb_at_iconnect.co.za Received on Wed Jul 15 1998 - 09:06:40 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US