How to implement DOMAINs?

Hello everybody,

just came across the question how to implement SQL domains in ORACLE. What I would like to do is something like this:

CREATE DOMAIN AREACODE AS CHAR(5) CONSTRAINT VALID_AREA CHECK ( LENGTH(VALUE)=5 ) Any ideas?

Johann Received on Mon Apr 07 2003 - 02:11:43 CDT