help for trigger [message #41278] |
Fri, 13 December 2002 04:33 |
Patzschke Steffen
Messages: 1 Registered: December 2002
|
Junior Member |
|
|
hello freaks,
how can i save a current record (one to one), befor this updating, in a other table (self structure + update column --> Date)????
thank you for help
|
|
|
Re: help for trigger [message #41281 is a reply to message #41278] |
Fri, 13 December 2002 08:45 |
B
Messages: 327 Registered: August 1999
|
Senior Member |
|
|
SQL> create table NEW ( id# number(1) );
Table créée.
SQL> create table OLD ( id# number(1), update_date date );
Table créée.
SQL> insert into new values ('1');
1 ligne créée.
SQL> commit;
SQL> l
1 create or replace trigger UPDATE_NEW
2 before update on NEW
3 for each row
4 begin
5 insert into OLD values ( :old.id#,sysdate );
6* END;
SQL> /
Déclencheur créé.
SQL> select * from NEW;
ID#
----------
1
SQL> select * from OLD;
aucune ligne sélectionnée
SQL> update NEW set id#=2;
1 ligne mise à jour.
SQL> commit;
Validation effectuée.
SQL> select * from NEW;
ID#
----------
2
SQL> select * from OLD;
ID# UPDATE_DAT
---------- ----------
1 13/12/2002
|
|
|