Oracle express 11g? Constraints

[BAHA]

I want to set up a CHECK constraint for an ID i.e CON12345, it has to have those three characters "CON" at the front and 5 numbers that follows that?

[rski]

if this is a new table you can saet check when you create table

create table test (
id varchar2(9), 
constraint id_chk check(regexp_like(id,'CON[0-9]{5}'))
);

if table already exist you can add check constraint

alter table test add constraint id_chk(check(regexp_like(id,'CON[0-9]{5}'))

[BAHA]

Thanks it works. i found all of these types of constraints on oracle's website