Re: Check Constraints

From: Joshua <a.j.van.rooijen_at_bluevision.nl>
Date: Mon, 18 Mar 2002 11:17:05 GMT
Message-ID: <R0kl8.396807$hy4.16398396@Flipper>

you can do that by making database triggers update and/or insert and put the validation code in these.

"casper44" <dkniveton71_at_msn.com> wrote in message news:be3be537.0203170526.a793d85_at_posting.google.com...
> How do I check to make sure a attribute of type VARCHAR2 is greater
> than 2 characters? For example if I create a table and the attribute
> is:
>
> organization VARCHAR2(50) NOT NULL,
>
> and I also want it to always be greater than 2 characters.
>
> Thanks.
Received on Mon Mar 18 2002 - 05:17:05 CST