1,105,344 Community Members

oracle primary key and foreign key within same table

Member Avatar
tony75
Posting Whiz in Training
265 posts since Mar 2011
Reputation Points: 10 [?]
Q&As Helped to Solve: 4 [?]
Skill Endorsements: 0 [?]
 
0
 

How can I insert two row to supplier table?

CREATE TABLE supplier (
    supplier_nr NUMBER(10),

    supplier_id VARCHAR2(20) NOT NULL,

    price   NUMBER(10) NOT NULL,

    CONSTRAINT supplier_supplier_nr_pk PRIMARY KEY(supplier_nr),
    CONSTRAINT supplier_supplier_id_fk FOREIGEN KEY(supplier_id)
        REFERENCES varugrupp(supplier_id)
);
Member Avatar
pritaeas
mod_pritaeas
11,291 posts since Jul 2006
Reputation Points: 1,420 [?]
Q&As Helped to Solve: 1,832 [?]
Skill Endorsements: 155 [?]
Moderator
Featured
Sponsor
 
0
 

Insert the rows with a unique supplier_nr for each row and an existing supplier_id.

Member Avatar
tony75
Posting Whiz in Training
265 posts since Mar 2011
Reputation Points: 10 [?]
Q&As Helped to Solve: 4 [?]
Skill Endorsements: 0 [?]
 
0
 

Can you give me one example please!

Member Avatar
pritaeas
mod_pritaeas
11,291 posts since Jul 2006
Reputation Points: 1,420 [?]
Q&As Helped to Solve: 1,832 [?]
Skill Endorsements: 155 [?]
Moderator
Featured
Sponsor
 
0
 
INSERT INTO supplier VALUES (1, 'ID', 10)

The values shown above depend on what is already in your tables, so you may need to change those. For example 'ID' needs to be in the varugrupp table.

Member Avatar
tony75
Posting Whiz in Training
265 posts since Mar 2011
Reputation Points: 10 [?]
Q&As Helped to Solve: 4 [?]
Skill Endorsements: 0 [?]
 
0
 

THANKS SIR

Question Answered as of 1 Year Ago by pritaeas
You
This question has already been solved: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: