Say i have have this table:
CREATE TABLE Membre
nomMembre VARCHAR(30) NOT NULL,
prenomMembre VARCHAR(30) NOT NULL,
adresseMembre VARCHAR(30) NOT NULL,
dateNaissMembre DATE NOT NULL,
dateInscriptionMembre DATE NOT NULL,
PRIMARY KEY (noMembre) ... ... ...
If I want to check that the column say... "nomMembre" has it's first four letters all in uppercase, how can I do it? I was trying with CHECK(UPPER(SUBSTR but i think I'm not using it good...
Any help is appreciated!
This way it worked:
create table mytest(v varchar2(10) check (upper(substr(v, 1, 4)) = substr(v, 1, 4) ))
Click Here to Expand Forum to Full Width