oracle中的trigger

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 --创建表CREATE? TABLE? tab1 (tid NUMBER(4) PRIMARY? KEY,tname VARCHAR2(20),tage NUMBER(2));CREATE? TABLE? tab2 (tid NUMBER(4),ttel VARCHAR2(15),tadr VARCHAR2(30));--插入数据INSERT? INTO? tab1 VALUES(101,22);INSERT? INTO? tab1 VALUES(102,‘yang‘,20);INSERT? INTO? tab2 VALUES(101,‘13761512841‘,‘AnHuiSuZhou‘);INSERT? INTO? tab2 VALUES(102,‘13563258514‘,‘AnHuiSuZhou‘);--创建视图连接两张表CREATE? OR? REPLACE? VIEW? tab_view AS? SELECT? tab1.tid,tname,ttel,tadr FROM? tab1,tab2 WHERE? tab1.tid = tab2.tid;--创建触发器CREATE? OR? REPLACE? TRIGGER? TAB_TRIGGER?INSTEAD? OF? INSERT? ON? TAB_VIEWBEGIN?INSERT? INTO? TAB1 (TID,TNAME) VALUES? (:NEW.TID,:NEW.TNAME);?INSERT? INTO? TAB2 (TTEL,TADR) VALUES? (:NEW.TTEL,:NEW.TADR);END;/--现在就可以利用视图插入数据INSERT? INTO? tab_view VALUES(106,‘ljq‘,‘13886681288‘,‘beijing‘);--查询SELECT? * FROM? tab_view;SELECT? * FROM? tab1;SELECT? * FROM? tab2;

（编辑：晋中站长网）

【声明】本站内容均来自网络，其相关言论仅代表作者个人观点，不代表本站立场。若无意侵犯到您的权利，请及时与联系站长删除相关内容!

5)、创建触发器，利用视图插入数据