• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

update oracle table with SQL loader??

 
Daves Chan
Greenhorn
Posts: 1
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hi All,

I'm not sure if this is the right place to ask this kind of question, so pls forgive me if I go to the wrong place.

Can anyone tell me what should I do if I need to update a oracle table base on an external data file? I used to do it manually with SQL loader but want to complete it thru Java program now. Can anyone give me a direction how to do it? A JDBC connection + I/O API and then update the record one by one?? Is there any more effieient way? thanks.
 
Ilja Preuss
author
Sheriff
Posts: 14112
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Moving to our Oracle forum...
 
Jeanne Boyarsky
author & internet detective
Marshal
Posts: 33671
316
Eclipse IDE Java VI Editor
  • 0
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Dave,
Welcome to JavaRanch!

Take a look at the batch update methods in JDBC. The JDBC tutorial gives an example.

While sql loader is Oracle specific, updates in JDBC are not. So I'm moving this to the JDBC forum where it better fits and will get more views.
 
Consider Paul's rocket mass heater.
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic