17,086
社区成员
发帖
与我相关
我的任务
分享
create or replace trigger triiger_delete_users
before delete on t1
for each row
begin
//此处要求不要删除数据,阻止接下来的删除
end triiger_delete_users;
create view v_t1 as select * from t1;
create or replace TRIGGER v_t1_trigger
instead of delete
ON V_T1
FOR EACH ROW
BEGIN
dbms_output.PUT_LINE('Could not delete');--如果你什么也不想输出,这里写 null;
END;
--test
delete from v_t1 where id = 44;
1 rows deleted
Could not delete
--还会发现,直接从表里删也是不行的,会报错
delete from t1 where id = 44;
Error starting at line 1 in command:
.....