Home » SQL & PL/SQL » SQL & PL/SQL » database trigger to restrict deleting
database trigger to restrict deleting [message #37551] Wed, 13 February 2002 23:05 Go to next message
ranjan kumar dash
Messages: 15
Registered: February 2002
Junior Member
I have written a database trigger on emp table that it will not allow any user to delete any row.How i will do it
create or replace trigger delete_trig
before delete
for each row
declare

Report message to a moderator

Re: database trigger to restrict deleting [message #37556 is a reply to message #37551] Thu, 14 February 2002 00:56 Go to previous message
pratap kumar tripathy
Messages: 660
Registered: January 2002
Senior Member
create or replace trigger emp_delete_trig
before delete
on emp
for each row
begin
raise_application_error(-20010,'You can not delete record from this table');
end;
/

Report message to a moderator

Previous Topic: nested loops
Next Topic: Orackle Package
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Sun May 18 17:24:19 CDT 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.