TRIGGER BEFORE/AFTER INSERT
Posted by:
j j
Date: August 28, 2009 12:09AM
I created a table that stores the gender of a person. Before or after inserting (which ever is best) I would like to verify that the sex entered is either (male or female) case insensitive.
Firstly is this the best way to store gender, secondly how would I go about creating a trigger. Thankyou
Subject
Written By
Posted
TRIGGER BEFORE/AFTER INSERT
August 28, 2009 12:09AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.