Re: Seeking Equivalent of InterBase Domain

From: Martijn Tonies <m.tonies_at_upscene.removethis.com>
Date: Sat, 20 Jan 2007 20:12:56 +0100
Message-ID: <12r4qhfdsshv0a2@corp.supernews.com>

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

No, it does not ... Domains are not equivalent to "types".

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

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).

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.

-- 
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com

Received on Sat Jan 20 2007 - 13:12:56 CST