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: Jim Smith <usenet01_at_ponder-stibbons.com>
Date: Mon, 22 Jan 2007 09:20:33 +0000
Message-ID: <oYNiWIUhHItFFwid@jimsmith.demon.co.uk>


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".

-- 
Jim Smith
Ponder Stibbons Limited <http://oracleandting.blogspot.com/>
RSS <http://oracleandting.blogspot.com/atom.xml>
Received on Mon Jan 22 2007 - 03:20:33 CST

Original text of this message

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