Re: CREATE DOMAIN in Oracle?

From: Mark D Powell <mark.powellNOmaSPAM_at_eds.com.invalid>
Date: 2000/08/09
Message-ID: <0434033a.03fbe3df@usw-ex0102-015.remarq.com>#1/1

"Finn Ellebaek Nielsen" <fen_at_changegroup.dk> wrote:
>You can create objects (CREATE TYPE AS OBJECT...) and emulate
 domains that
>way.
>
>HTH.
>
>Finn
>
><martin_suttrup_at_my-deja.com> wrote in message
>news:8kn272$9ai$1_at_nnrp1.deja.com...
>> In article <396EE2B8.7AEB43E0_at_kom.tu-darmstadt.de>,
>> Ivica Rimac <rimac_at_kom.tu-darmstadt.de> wrote:
>> > How can I create a DOMAIN in Oracle?
>> >
>> > CREATE DOMAIN ... --> ???
>> >
>> > Thanx
>> > --
>> >
>> > Best regards,
>> >
>> > ___Ivica

 Rimac_________________________________________________


>> >

>> No.
>>

I think the answer has to do with what the original poster means by domain? I am use to seeing the term used in a manner where it basically means the range of legal values for an attribute.

If this is the case then the column datatype and a check constraint can often be used to enforce that the value stored is a member of the set of legal values, i.e., the domain.

Where a check constraint is not enough then a before trigger can be used to provide more complex value editing.

• Mark D. Powell -- The only advice that counts is the advice that you follow so follow your own advice. --

  ---

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Wed Aug 09 2000 - 00:00:00 CDT