File APIs for Java Developers
Manipulate DOC, XLS, PPT, PDF and many others from your application.
The moose likes JDBC and Relational Databases and the fly likes update oracle table with SQL loader?? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Bookmark "update oracle table with SQL loader??" Watch "update oracle table with SQL loader??" New topic

update oracle table with SQL loader??

Daves Chan

Joined: Jul 30, 2005
Posts: 1
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

Joined: Jul 11, 2001
Posts: 14112
Moving to our Oracle forum...

The soul is dyed the color of its thoughts. Think only on those things that are in line with your principles and can bear the light of day. The content of your character is your choice. Day by day, what you do is who you become. Your integrity is your destiny - it is the light that guides your way. - Heraclitus
Jeanne Boyarsky
author & internet detective

Joined: May 26, 2003
Posts: 33130

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.

[OCA 8 book] [Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Other Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, TOGAF part 1 and part 2
I agree. Here's the link:
subject: update oracle table with SQL loader??
It's not a secret anymore!