"Ann W. Harrison" <aharrison@...> wrote:

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


> For what it's worth, InterBase and Rdb/ELN before it had domains
> with the ability to put constraints (called validity conditions)
> from the early 1980's. The high level query language at DEC used
> domain linkages to predict logical joins between tables, and it
> was considered crude to define a field's data type in a table
> (relation) definition. Of course, none of this was SQL, but it
> was based on Codd's papers.

A far better way of course than having to define the
same thing all over a db where such a construct is
required - but what I'm really looking for is when it
arrived in Oracle? I think it is there now.


TIA and rgs,


Paul...

> ann