Re: Question about check constraint

From: Edelstein <info_at_rbsbooks.com>
Date: 1997/05/19
Message-ID: <MPG.dea5b503903ce8398968a@snews.zippo.com>#1/1

In article <864055106.15780_at_dejanews.com>, tomas_at_senna.std.lt says...
> Does anybody know is it possible create check constraint that restrict
> updating or inserting into table columns of varchar2 type values that
> have numbers or others symbols ex: test11 not allowed test[ not allowed
> test allowed
>
> -------------------==== Posted via Deja News ====-----------------------
> http://www.dejanews.com/ Search, Read, Post to Usenet
>

check(ltrim(column_name,'ABCDEFGHIJKLMNOPQRSTUVWXYZabc....')is null) is one way. If everything in column_name is found in the string, ltrim will strip all chars away and return null.

Fran Edelstein
Author of Learning Oracle Database Programming http://www.rbsbooks.com Received on Mon May 19 1997 - 00:00:00 CDT