Re: String and date format

For the first question, try something like (there is no regular expression support)...

CREATE TABLE table_name ( column_name VARCHAR2 (4) CONSTRAINT ck_column_name CHECK ( LTRIM (SUBSTR (column_name, 1, 2), 'ABCDEFGHIJKLMNOPQRSTUVWXYZ') IS NULL AND LTRIM (SUBSTR (column_name, 3, 2), '0123456789') IS NULL)); For the second, DATE is always stored internally in the same format. Only difference is how you format is when you fetch it back.

--
Padderz
SYSOP, RevealNet PL/SQL Pipeline
Senior Oracle Developer, Cellular Operations UK

Posted via dBforums
http://dbforums.com