3,491
社区成员
发帖
与我相关
我的任务
分享
SQL> create table t_rigofree (a int,b int, c int , d int);
Table created.
SQL>
SQL>
SQL> CREATE or REPLACE TRIGGER trg_OTSNO
2 BEFORE INSERT ON t_rigofree
3 FOR EACH ROW
4 Begin
5 IF :NEW.a IS NULL THEN
6 :NEW.a := :NEW.c;
7 END IF;
8
9 IF :NEW.b IS NULL THEN
10 :NEW.b := :NEW.d;
11 END IF;
12 End;
13 /
Trigger created.
SQL> insert into t_rigofree(a,b,c,d) values (1,2,3,4);
1 row created.
SQL> select * from t_rigofree;
A B C D
---------- ---------- ---------- ----------
1 2 3 4
SQL> insert into t_rigofree(c,d) values (33,44);
1 row created.
SQL> select * from t_rigofree;
A B C D
---------- ---------- ---------- ----------
1 2 3 4
33 44 33 44
SQL>
SQL> create table t(x int default 0);
Table created
SQL> insert into t values(default);
1 row inserted
SQL> select * from t;
X
---------------------------------------
0