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!

to insert two text file into oracle table

00125May 22 2012 — edited May 22 2012

Hi all,

I am new to oracle technology..I want to insert data into table by using two text file..

EG:
text1.txt contains employee_id,Employee_name,address

text2.txt contains department_id and department_name

I want to insert the data into table employee having column employee_id,employee_name,address,department_id, department_name..

By using single control file I want to solve dis..I have google it But I can't get idea..

This post has been answered by ShankarViji on May 22 2012

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Jun 19 2012

Added on May 22 2012

15 comments

418 views