Re: SQL*Plus Constraints

In article <2vc2isINNiar_at_ope001.iao.ford.com>, Mark J. Bobak <mbobak_at_tr1106.to.ford.com> wrote:
>In article <BGraham.7.2E15EB0A_at_gandalf.otago.ac.nz>,
>Bryce Graham <BGraham_at_GANDALF.OTAGO.AC.NZ> wrote:
>>Hi,
>>
>>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.

Ok, foot in mouth....I knew something seemed too simple.....I didn't realize he was referring to a constraint....

Sorry people. My mistake.

-Mark

-- 
Mark J. Bobak
Truck Operations
Ford Motor Company
bobak_at_mailhost.to.ford.com