create view vtest as select * from t_post;
--然后在view上建触发器,以后每次就通过修改view来修改原表
create or replace trigger test
INSTEAD OF INSERT OR UPDATE ON emp_info
FOR EACH ROW
declare
begin
insert into emp_info_bk values('''.'|');
end test;
--然后在view上建触发器,以后每次就通过修改view来修改原表
create or replace trigger test
INSTEAD OF INSERT OR UPDATE ON emp_info
FOR EACH ROW
declare
begin
insert into emp_info_bk values('''.'|');
end test;
INSTEAD OF INSERT OR UPDATE ON emp_info
FOR EACH ROW
declare
begin
insert into emp_info_bk values(''','|');
end test;