Unanswered: How to create CHECK constraint on table
I need to add a "check constraint" on a varchar2 column.
The constraint is:
the value in the column must be either numbers or characters a-z or A-Z. It should not have any special chars such as ~!@#$%^& etc......
What could be the syntax ?
for example for a "Check of T or F " on column "name" will be like this.
create table test1 (
NAME CHAR(1) CONSTRAINT Con1
CHECK (UPPER (NAME) IN ('T', 'F')),
similarly I want to check the DESC column is either 0-9 or a-z or A-Z or combination of numbers and characters.