This week's book giveaway is in the Servlets forum.
We're giving away four copies of Murach's Java Servlets and JSP and have Joel Murach on-line!
See this thread for details.
The moose likes JDBC 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


Win a copy of Murach's Java Servlets and JSP this week in the Servlets forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "update oracle table with SQL loader??" Watch "update oracle table with SQL loader??" New topic
Author

update oracle table with SQL loader??

Daves Chan
Greenhorn

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
author
Sheriff

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
internet detective
Marshal

Joined: May 26, 2003
Posts: 30076
    
149

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.


[Blog] [JavaRanch FAQ] [How To Ask Questions The Smart Way] [Book Promos]
Blogging on Certs: SCEA Part 1, Part 2 & 3, Core Spring 3, OCAJP, OCPJP beta, TOGAF part 1 and part 2
 
wood burning stoves
 
subject: update oracle table with SQL loader??
 
Similar Threads
Use PL/SQL Loop and variable
Transaction or Table Locking?
some value too large for some column and getting a SQL trace from Oracle, a 30 year old database
Oracle SQL Loader
Oracle help urgent