EXAMPLE1:
Create or Replace Trigger mytrig
Before
Delete
on Emp
Begin
Raise_apllication_error(-20000,'sorry we cannot delete the record from the table);
End;
EXAMPLE2:
Create or Replace Trigger mytrig
Before
Delete or Update or Insert
on Emp
Begin
Raise_apllication_Error(-20000,'Sorry we cannot Perform any DML operations on Emp table');
End;
No comments:
Post a Comment
If you Like my blog Spread it and help friends for whom this blog is useful for their career.