On the move:

I'm currently moving the following to their own blogs: Unix, HTML for Blogs, Perl & Java.
The links are on the left side.

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