Re: Seeking Equivalent of InterBase Domain

First off... being new to this newsgroup, I find it refreshing to find it so active with people smarter than myself :)

Daniel, you have reiterated several times the statement "What is it you can not do in Oracle". Further, you mention constraints can built on data types, yet others state this as not being possible.

So, can you at least humor me, and submit such an animal. Perhaps a simple example, a "BOOL_TYPE", which is what got this thread started. Here again in Interbase syntax is the initial posting.

Then maybe we can put this little debate to rest.

######################################################################
create domain BOOLEAN_DOMAIN as CHAR(1) default 'N' NOT NULL check ((VALUE = 'N') or (VALUE = 'Y'));
######################################################################

Regards,
Monte Carver Received on Mon Jan 22 2007 - 20:40:49 CST