how limit datatype on columns........

[raf]

hi,
I have this col in table tab_X

X_ID........varchar2(32)

I'd like to limit the insert at max 8 characters.

For example:
insert into tab_X (X_ID) values ('00112233');
correct

insert into tab_X (X_ID) values ('001122334455');
incorrect (error)

How can I limit X_ID at max length=8??

Thanks

[jmodic]

Check constraints!

alter table tab_X add constraint check_length check (length(X_ID)<=8);

But don't you think your table is designed improperly? If yor X_ID should accept at most 8 characters, why do you have column declared as varchar2(32)? Why not simply define it as varchar2(8) and the propper length check will be performed automaticaly?