SQL & PL/SQL

Hi all,

My requirement is User should not enter the data like ( ½, ¼,...).
I have created table with check constraint with the following syntax:


CREATE TABLE mytest (c1 VARCHAR2(20),
CHECK (REGEXP_LIKE(c1,'^[[:alnum:]+[:digit:]+[!@#]]+$')));

The above means, except alphanumeric, digits, and keyboard characters should allow. But it is not allowing any characters.

Please help me, any mistake in the above syntax.

Thanks
Mano