| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.tools -> Execute trigger on current row
Hi,
I'm trying to write a trigger that updates a date field after an insert. However, I want to only update that row's date field. I can't do a "where" qualification because the fields they enter can vary.
How would I update the field only for the inserted row?
Right now I have something like this which sets all the
dates in the table:
CREATE OR REPLACE TRIGGER CREATED_DATE AFTER INSERT ON
SOMETABLE
begin
UPDATE SOMETABLE SET created = sysdate;
end;
/
Is there an "on current row" qualification of some sort?
Oracle 8.1.6
TIA
Sent via Deja.com http://www.deja.com/
Before you buy.
Received on Thu Sep 21 2000 - 00:00:00 CDT
 |
 |