Oracle database foreign key constraints

Question

I am new to oracle and i'm trying to create a foreign key to another table

CREATE TYPE Salary_typ AS OBJECT (
    Sal_SlipId NUMBER (11),
    Sal_BankDetails VARCHAR (255),
    Sal_Salary NUMBER (11,2),
    Sal_Month VARCHAR (255),
    Sal_Employee REF Employee_typ
    )
    /

this is the type that i created

and this is the table

CREATE TABLE Salary OF Salary_typ (
    Primary Key (Sal_SlipId),
    Sal_Employee REFERENCES Employee 
    )
    /

I tried executing these but all i get is a garbage value for foreign key

Tony Andrews · Accepted Answer · 2020-04-06 16:54:51Z

1

If you are new to Oracle, don't try to create tables based on types - nobody does that!

Do this instead:

create table salary (
    Sal_SlipId NUMBER (11),
    Sal_BankDetails VARCHAR (255),
    Sal_Salary NUMBER (11,2),
    Sal_Month VARCHAR (255),
    Sal_Employee REFERENCES employees
);

answered Apr 6, 2020 at 16:54

Tony Andrews

133k23 gold badges230 silver badges266 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Group Assignment Over a year ago

Is there a way to this with a type?

Collectives™ on Stack Overflow

Oracle database foreign key constraints

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related