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

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@x.washington.edu
(replace x with u to respond)