Re: Help with constraints on object relational tables

Stephen Reid wrote:
> Hi
>
> I hope I am posting in the correct places. I am looking for some help that
> is hopefully explained in the example below:
>
> I am looking to create an object relational database with a check constraint
> on the relationships. For example:
>
> * I have table called person_tab which is a table of person_t type.
> * Person_t type is inherited by the manager_t type and the applicant_t type.
> * I have a second table called interview_tab of interview_t type.
> * The interview table has two columns (manager and appilcant) that are scope
> restrained to the person table.
> * I would also like to put check constraints on these columns to say:
> ----- Manager: check the person_number is less than 20000
> ----- Applicant: check the person_number is greater than 19999
>
> Can anyone tell me if this is possible and if so how can it be done?
>
> Thanks in advance
> Stephen

This is a bad idea. Create relational tables and object views. You can find numerous comments on this at http://asktom.oracle.com.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)