Re: Seeking Equivalent of InterBase Domain

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>