Re: Seeking Equivalent of InterBase Domain

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 22 Jan 2007 11:49:17 -0800
Message-ID: <1169495352.913842@bubbleator.drizzle.com>

Jim Smith wrote:
> In message <1169489558.935801_at_bubbleator.drizzle.com>, DA Morgan
> <damorgan_at_psoug.org> writes

>> Jim Smith wrote:
>>> In message <1169405574.80550_at_bubbleator.drizzle.com>, DA Morgan 
>>> <damorgan_at_psoug.org> writes
>>>> Martijn Tonies wrote:
>>>>
>>>>> Can you assign a "check constraint" to a type?
>>>>
>>>> CREATE TABLE department_mgrs (
>>>>  dept_no     NUMBER PRIMARY KEY,
>>>>  dept_name   CHAR(20),
>>>>  dept_mgr    person_typ,
>>>>  dept_loc    location_typ,
>>>>  CONSTRAINT  dept_loc_cons1
>>>>      UNIQUE (dept_loc.building_no, dept_loc.city),
>>>>  CONSTRAINT  dept_loc_cons2
>>>>       CHECK (dept_loc.city IS NOT NULL) );
>>>>
>>>  So that would be "No".
>>
>> You have a different interpretation of:
>>
>> CHECK (dept_loc.city IS NOT NULL) );
>>
>> Than I do.

>
> As discussed earlier in the thread, the requirement is to create a type
> and add a constraint to the type. Not apply the constraint to a column
> which uses the type.
>
> e.g.
>
> create type positive_integer number(10,0) contraint pos_con (check
> positive_integer > 0);
>
> create table x
> ( ...
> age positive_integer,
> ...
> );
>
> This can't be done in oracle.

Use the CREATE TYPE BODY to define or implement the member methods defined in the object type specification. You create object types with the CREATE TYPE and the CREATE TYPE BODY statements. The CREATE TYPE statement specifies the name of the object type, its attributes, methods, and other properties. The CREATE TYPE BODY statement contains the code for the methods that implement the type.

Source:
http://download-west.oracle.com/docs/cd/B19306_01/server.102/b14200/statements_8002.htm#SQLRF01502

What is it you can not do in Oracle?

-- 
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 Mon Jan 22 2007 - 13:49:17 CST