oracle´¥·¢Æ÷£¡°ï°ï棡 - Oracle / ¿ª·¢

ÐèҪдһ¸ö´¥·¢Æ÷£¬ÔÚ¸üÐÂÒ»¸öÌõÊý¾ÝµÄʱºò£¬Òª°ÑÕâÌõÔ­Êý¾Ý£¬´æÈëÁíÒ»¸ö±í£¡

ÒªÔõôд°¡£¿

ÎÒ¶Ô´¥·¢Æ÷²»ÊǺÜÊìϤ£¡Çë¸ßÊÖ°ï°ï棡ллÁË£¡

---

create or replace trigger tri_name
before inser on table_a
for each row
insert into table_b(:new.col1,..,:new.coln);
end;

---

insert »¹Ò»¸öbegin

---

ÄãÌ«ÀÁÁË

---

ÒýÓÃ

create or replace trigger tri_name
before inser on table_a
for each row
insert into table_b(:new.col1,..,:new.coln);
end;

insertÐÞ¸ÄΪupdate
:newÐÞ¸ÄΪ:old

---

SQL code:
CREATE TRIGGER [TRIGGER_UPDATE_TableA]
BEFORE INSERT ON [TableA]
FOR EACH ROW
INSERT INTO[TableB]();
END

---

лл¥ÉÏÐÞÕý ÖÐÎçû˯¾õ ÔÎÔ뵀 ºÇºÇ

---

create or replace trigger trigger_update_name
before update on table_name
for each row
begin
insert into old_data_talbe values(:old.column_name,..);
end;

ÒªÏȽ¨¸ö·ÅÔ­Êý¾ÝµÄ±í¹þ¡£

---

ÒýÓÃ

create or replace trigger trigger_update_name
before update on table_name
for each row
begin
insert into old_data_talbe values(:old.column_name,..);
end;

ÒªÏȽ¨¸ö·ÅÔ­Êý¾ÝµÄ±í¹þ¡£

·ÅÔ´Êý¾ÝµÄ±í£¿ÁíÍ⽨һ¸ö±íÂð£¿

---

ÒýÓÃ

ÒýÓà 7 Â¥ yo