Skip to Main Content
Forums

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to insert data into two tables linke with foreign key..

783295Jul 8 2010 — edited Jul 9 2010
I have two tables
1)EMP(emp_ID,username,emp_type_code)
emp_ID is primary key, emp_type_code is a foreign key references emptype table.

2)emptype(emp_type_code,emp_type_descripton)
emp_type_code is primary key



Could anyone help me ..how to insert data into EMP table. How to insert data into two tables linke with foreign key..
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Aug 6 2010
Added on Jul 8 2010
6 comments
4,405 views