Re: Seeking Equivalent of InterBase Domain

Martijn Tonies wrote:

>> Once again Oracle has this capability and has had it since at least
>> version 8.0.6.

I didn't say they were. I said they could be used to meet the OP's requirement.

> Types is a different beast, and useful in its own respect.

And useful in the same respect for the OP.

> Domains basically create a very small sub-type of an existing
> raw datatype and may include an optional check constraint.
> This domain can then be used in column definitions.
 >
> An Oracle "type" is a much more complex than that and only
> introduced in Ora 8, while "domains" is a much older "thing"
> in the RDBMS world (and has been in InterBase for ages).

I did state that above if you look at the first sentence.

> The closest thing I have come around that is similar to InterBase
> "domains" is the SQL Server "user defined type" before SQL 2005
> came along.
>
> Hope this helps.

And what can you do with them that you can not do with an Oracle user defined type with (or without) methods?

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace x with u to respond)
Puget Sound Oracle Users Group
www.psoug.org