Hi all,

I'm doing a thesis on databases for my degree
at night (last year, please God) and I was
putting forward the case that Open Source db's
are often as good as commercial ones.

The syntax

CREATE DOMAIN RoomType AS CHAR(1)
CHECK(VALUE IN (‘S’, ‘T’, ‘D’));

has been valid in Interbase/Firebird ever since
I saw my first IB db over 10 years ago.

I was just wondering when it became valid in Oracle?

I seem to remember a few people (round here?) being
not a little pleased that they were so far ahead of
Oracle!

I have Googled, but can't find anything. The best I found
was this
http://www.dbforums.com/oracle/1611502-how-create-domain.html

but it dates from 2004.

Any pointers or URLs welcome!

TIA and rgs,


Paul...