William Robertson wrote:
> MRCarver wrote:
>> Daniel,
>>
>> Thanks again for the attention !
>>
>> Can one further define the TYPE with a constraint? Something like:
>>
>> CREATE OR REPLACE TYPE Bool_DOM OBJECT (
>> Bool_DOM VARCHAR2(1) with CONSTRAINT BoolChk ((Bool_DOM IN('Y', 'N"))
>> );
>
> I hadn't come across Interbase or its Domain feature before but it
> sounds like quite a nice idea. Oracle doesn't have anything like this.
This capability was built into Designer and likely still is there. I
just don't know anyone currently utilizing the tool. The object was
identified as a DOMAIN as stored the definition as metadata in the
repository.
--
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 Sat Jan 20 2007 - 12:23:40 CST
