Re: Seeking Equivalent of InterBase Domain

From: Martijn Tonies <m.tonies_at_upscene.removethis.com>
Date: Wed, 24 Jan 2007 11:05:54 +0100
Message-ID: <12rebvor791jfa7@corp.supernews.com>

> > Oh give it up. Providing domains in a case tool is entirely different
> > from providing them in the dbms.
>
> True. In one case you get the functionality and in the other you get
> to whine about something Oracle doesn't provide.
>
> I'm still looking for something you can do with a domain that can not
> be done in Oracle. I'm not saying it doesn't exist. I just have yet to
> see anyone name it.

Daniel, I've asked several times now and you didn't reply.

Can you apply a check constraint to your "type" object at the type level, NOT at the column level?

This would be more-or-less equal to a "domain" as used by InterBase and Firebird.

-- 
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 Wed Jan 24 2007 - 04:05:54 CST