| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Usenet -> c.d.o.misc -> Re: Check constraint violated
Originally posted by Me
> On Fri, 13 Jun 2003 21:33:43 +0530, Me wrote:
> >2) How can I put a check constraint that allows entering data
> into apointee only
> >if the nominee's age is lesser than 18?
>
> Could someone help me with this constraint.
>
> Thanks.
ALTER TABLE appointee
ADD CONSTRAINT chk_nominee_age CHECK (age < 18);
-- Posted via http://dbforums.comReceived on Sat Jun 14 2003 - 06:33:48 CDT
 |
 |