Re: Check constraint violated

From: Sybrand Bakker <gooiditweg_at_nospam.demon.nl>
Date: Sat, 14 Jun 2003 13:38:25 +0200
Message-ID: <c72mevo1crop25g8cgufng5u0nakndip75@4ax.com>

On Sat, 14 Jun 2003 12:50:48 +0530, Me <somebudy_at_despammed.com> wrote:

>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.

Trying to avoid to read the manual are we?

decode(sign(<age_column> - 18), 1, false, 0, false, true)

Sybrand Bakker, Senior Oracle DBA

To reply remove -verwijderdit from my e-mail address Received on Sat Jun 14 2003 - 06:38:25 CDT