How to create a inheritance table in oracle10g

Question

0.00/5 (No votes)

See more:

I have 3 tables , i know that it is an interference condition

table person(P_ID,Name,Age)
table owner (O_ID,Insuranceinfo)
table driver(D_ID,Licensenumber)

I created the parent table Person:

create table person(
P_id Integer Primary Key,
name char(30),
age integer
)

What I have tried:

create table owner(
o_id Integer Primary Key,
Insuranceinfo char(30)
)
INHERITS(person)

Posted 4-Mar-20 8:18am

Abed Al Rahman Hussien Balhawan

Updated 4-Mar-20 8:35am

Add a Solution

1 solution

Add a Solution

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Wendelius · Answer 1 · 2020-03-04T08:35:00

Solution 1

In Oracle you would use a type definition. Have a look at CREATE TYPE[^], including UNDER definition.

After creating the type you would use it in CREATE TABLE[^] in order to create an object table.

Posted 4-Mar-20 8:35am

Wendelius

Comments

Abed Al Rahman Hussien Balhawan 4-Mar-20 14:55pm

something like that ?
CREATE OR REPLACE TYPE PERSON AS OBJECT (
P_ID integer,
Name Char(20),
Age Integer
);

Wendelius 4-Mar-20 22:59pm

For the type definition yes, but I understood that you wanted a table so next step would be creating an object table of that type.

Have a look at the examples in CREATE TABLE documentation.

How to create a inheritance table in oracle10g

1 solution

Solution 1

Add your solution here

Preview 0

How to create a inheritance table in oracle10g

1 solution

Solution 1

Add your solution here

Preview 0

Existing Members

...or Join us