我的触发器原型:
表t1,只有一个字段id number类型的create or replace trigger triiger_delete_users
before delete on t1
for each row
begin
//此处要求不要删除数据,阻止接下来的删除
end triiger_delete_users;也说是说,删除前,经过此触发器后,不执行以下的
delete t1 where id=?了
求高手!
表t1,只有一个字段id number类型的create or replace trigger triiger_delete_users
before delete on t1
for each row
begin
//此处要求不要删除数据,阻止接下来的删除
end triiger_delete_users;也说是说,删除前,经过此触发器后,不执行以下的
delete t1 where id=?了
求高手!
应该这样写。。
2/4 PLS-00201: identifier 'RAILSE_APPLICATION_ERROR' must be declared
晕倒,少了个负号
raise_application_error(-200001,'不允许删除数据!');
刚才的RAISE多了个L....
:new.id=100000000000;--赋值一个 不存在的ID
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:
.....