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: MRCarver <mrcnewGroup_at_charter.net>
Date: Fri, 19 Jan 2007 15:34:19 -0800
Message-ID: <WBcsh.48$Ou1.37@newsfe04.lga>

> Well, first off .. InterBase <> Oracle. Don't try to reverse engineer
> to work like something else.

Not trying to reverse engineer, but simply trying to grasp Oracle's equivalent to Interbase's "DOMAIN". A "DOMAIN", such as in Interbase or in CASE tools like Embarcedero's ERStudio, describe commonly used data types with certain constraints. This way you define the constraint once, then simply bind it to a given field.
>
> Second, maybe I'm missing something, but it looks like you are wanting
> a boolean data type for a primary key column???? That would mean you
> could only ever have two rows in the table. I must be missing
> something.
>

Not primary key, just a field having boolean choices. Other examples of likely domains are

	"POSTAL_CODE_DOMAIN"
	"GENDER_DOMAIN"
	"ADDRESS_DOMAIN"
Received on Fri Jan 19 2007 - 17:34:19 CST

Original text of this message

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