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

Home -> Community -> Usenet -> c.d.o.misc -> Re: How to implement DOMAINs?

Re: How to implement DOMAINs?

From: andrewst <member14183_at_dbforums.com>
Date: Mon, 07 Apr 2003 15:40:15 +0000
Message-ID: <2738331.1049730015@dbforums.com>

Originally posted by Johann Sander
> > ...
> > Unfortunately, Oracle doesn't support the DOMAIN syntax. It
> does have
> > user-defined TYPEs, but these don't address the issue of
> specifying
> > constraints on the data values: you can only create constraints
> on
> > columns, not on TYPEs.
>
> That is pretty much frustrating. Is there no demand for something like
> this? I mean, it would help with data integrity issues, wouldn't it?
>

Yes, it is what the relational community really wanted when Oracle added user-defined types. I would love to see it.

--
Posted via http://dbforums.com
Received on Mon Apr 07 2003 - 10:40:15 CDT

Original text of this message

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