Re: How to implement SubType/SuperType in Oracle ?

From: <badrane.aime_at_neuf.fr>
Date: Wed, 15 Jun 2005 05:01:10 +0200
Message-ID: <d8o5q3$d40$1@apollon.grec.isp.9tel.net>

I think , you can try:

CREATE TYPE "my_super_type" .....etc

it's available since oracle8i;

<xtanto_at_hotmail.com> a écrit dans le message de news: 1118746309.163235.138790_at_g14g2000cwa.googlegroups.com...
> Hi,
>
> I have a supertype and three subtypes, as attached below, how is the
> best approach to implement it in Oracle (9i/10g) ?
>
> Thank you for your help,
> Krist
>
> Supertype : Employee
> Employee_Number
> Employee_Name
> Address
> Employee_Type
> Date_Hired
>
> SubType : Hourly_Employee
> Hourly_Rate
>
> SubType : Salaried_Employee
> Annual_Salary
> Stock_Options
>
> SubType : CONSULTANT
> Contract_Number
> Billing_Rate
>
Received on Tue Jun 14 2005 - 22:01:10 CDT