Re: Seeking Equivalent of InterBase Domain

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) );

Source:
http://download-west.oracle.com/docs/cd/B19306_01/appdev.102/b14260/adobjbas.htm#sthref215

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