Oracle认证辅导:oracle简单触发器 g2 l/ s0 x. B1 H/ k. S8 k
在tab_user_detail表增加一条数据后,往tab_user表增加一条记录, C) E6 O, E" [, c
create trigger tri_user_insert , A0 C; w. v1 d5 k4 `2 bafter insert on tab_user_detail7 h/ W9 h) w# B
for each row 0 { n8 C, r2 b" H Rbegin# G, c5 O, k" U/ f4 D
insert into tab_user (USER_ID,USER_NAME,USER_PWD,USER_CUSTOMERNAME,USER_PHOTOS) values (:new.MY_USERID,‘username’,‘password’,‘truename’,‘Default.jpg’);% b0 w' y3 ^9 K- Z; Y* ~
end;