Re: Question about check constraint

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


> 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

>