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!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Read data from a flatfile and update/insert into an Oracle table

274598Jun 19 2003 — edited Aug 14 2003

Hi.

Let say I have a text file called c:\data.txt containing:

100 John Manager
200 David Clerk

I also have a Oracle table called employee which consist of fields(ID,Name,Position).

Question:
Is there any way to do SQL command to read the data inside the flat file(c:\data.txt) and insert/update into the employee table?

Really appreciate if someone can help me on this matter.

Tq.

Locked Post

New comments cannot be posted to this locked post.

Locked on Sep 11 2003

Added on Jun 19 2003

6 comments

354 views