I'm building a set of tables at the moment and I want to be able to check
whether the age of an employee is > 16 and < 99. The employee's date of
birth is entered into the table and I want a column constraint to
automatically check that the age is between these two ages.
I've tried using MONTHS_BETWEEN but it won't allow me to use the SYSDATE
variable as the first date.
Any ideas on how to get around this would be greatly appreciated.
Post any request either to this newsgroup or I can be E-Mailed at
IS40511_at_Otago.ac.nz.
Thanks in Advance
Bryce Graham
Received on Sun Jul 03 1994 - 00:32:42 CEST