Re: how to prevent unwanted deletion
From: srivenu <srivenu_at_hotmail.com>
Date: 27 Feb 2002 23:08:55 -0800
Message-ID: <1a68177.0202272308.5f1a2393_at_posting.google.com>
begin
if :old.age >60 then
Date: 27 Feb 2002 23:08:55 -0800
Message-ID: <1a68177.0202272308.5f1a2393_at_posting.google.com>
create or replace trigger tr_bef_del_x
before delete on x
for each row as
begin
if :old.age >60 then
raise_application_error(-20100,'This row deletion not allowed: age >60');
endif;
end;
Received on Thu Feb 28 2002 - 08:08:55 CET