Tuesday, March 3, 2009

Trigger - Check for Positive Values

Create Or Replace Trigger PositiveOnly
Before Insert Or Update
Of DeptNo On Dept
For Each Row
Begin
If :new.DeptNo -20100, 'Please insert a positive value');
End If;
End PositiveOnly;
/

No comments:

Post a Comment