Re: Question about check constraint
From: flange <flange_at_pt.lu>
Date: 1997/05/21
Message-ID: <01bc661f$92f3c5c0$9bd79ac2_at_LangeFrancois>#1/1
Date: 1997/05/21
Message-ID: <01bc661f$92f3c5c0$9bd79ac2_at_LangeFrancois>#1/1
Hi
create table tab
(
col varchar2 ( 2000 ) constraint tab_col_ck check length ( translate ( col
, '0ABCDEFGHIJKLMNOPQRSTUVWXYZabcdefghijklmnopqrstuvwxyz' , '0' ) ) = 0 ,
...
)
Regards Francois Lange
-- F. Lange Certified DBA. tomas_at_senna.std.lt wrote in article <864055106.15780_at_dejanews.com>...Received on Wed May 21 1997 - 00:00:00 CEST
> 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
>