Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Seeking Equivalent of InterBase Domain

Re: Seeking Equivalent of InterBase Domain

From: DA Morgan <damorgan_at_psoug.org>
Date: Wed, 24 Jan 2007 13:51:37 -0800
Message-ID: <1169675492.634624@bubbleator.drizzle.com>


Martijn Tonies wrote:

>>> 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?

Not with a CHECK constraint as a that phrase is specific to a very specific object. But in many situations equivalent control can be achieved with a method: Something I have pointed to 4 or 5 times.

My issue here is not the name nor, yet again, am I claiming that Oracle has equivalent functionality ... I'm still just asking if there is something that can not be duplicated with an Oracle method. For example Oracle doesn't have IDENTITY columns but I can duplicate the functionality with a SEQUENCE.

-- 
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
Received on Wed Jan 24 2007 - 15:51:37 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US