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 -> Triggers to update same column upon insert

Triggers to update same column upon insert

From: Sanjay Kumar <skumar_at_nospam.com>
Date: 17 Apr 2003 12:47:39 -0700
Message-ID: <60608859.00001d9b.061@drn.newsguy.com>


I am new to Oracle.

Ver 8.1.7

Is it possible to declare a trigger to update the same column which is being inserted upon.

For e.g.,

insert into table_a(field_a) values(1);

and then declare a trigger on table_a which will update the value of field_a to field_a + 100. In effect all values of field_a gets incremented by 100 automatically after every insert. Received on Thu Apr 17 2003 - 14:47:39 CDT

Original text of this message

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