Thanks for the question, shahul.
Asked: May 25, 2022 - 5:57 am UTC
Last updated: May 26, 2022 - 12:25 pm UTC
Version: oracle datase 11g
Viewed 1000+ times
create table t ( c1 int ); create table t_archive ( c1_new int, c1_old int ); insert into t values ( 1 ); create trigger taufer after update on t for each row begin insert into t_archive values ( :new.c1, :old.c1 ); end; / update t set c1 = 42; select * from t_archive; C1_NEW C1_OLD ---------- ---------- 42 1
Check out more PL/SQL tutorials on our LiveSQL tool.
PL/SQL reference manual from the Oracle documentation library