17,377
社区成员
发帖
与我相关
我的任务
分享
SQL> create table t_test_tri
2 (a number,
3 b number);
Table created
SQL>
SQL> create or replace trigger tri_t_test_tri
2 before insert or update on t_test_tri
3 for each row
4 declare
5 begin
6 :new.b:=:new.a;
7 end tri_t_test_tri;
8 /
Trigger created
SQL> insert into t_test_tri values(1,0);
1 row inserted
SQL> select * from t_test_tri;
A B
---------- ----------
1 1
SQL> update t_test_tri set a=2;
1 row updated
SQL> select * from t_test_tri;
A B
---------- ----------
2 2
SQL>