AllExperts > Oracle 
Search      
Oracle
Volunteer
Answers to thousands of questions
 Home · More Oracle Questions · Answer Library  · Encyclopedia ·
More Oracle Answers
Question Library

Ask a question about Oracle
Volunteer
Experts of the Month
Expert Login

Awards

About Us
Tell friends
Link to Us
Disclaimer

 
 
 
 
About Peter Choi
Expertise
I am a senior Oracle DBA, PeopleSoft Administrator and Project Manager with 10+ years experience. I have been working with PeopleSoft (HRMS 5, 7, 7.x and 8.9), Oracle RDBMS (7.3 - 11gR1) on various Unix and Windows platforms, and some Oracle Application Server (9i/10gR2). I also have experience with the configuration and administration of BEA`s Tuxedo and WebLogic for PeopleSoft 8.x.

 
   

You are here:  Experts > Computing/Technology > Oracle > Oracle > data transfer from CSV file to database.

Oracle - data transfer from CSV file to database.

Expert: Peter Choi - 6/5/2009

Question
Hello Sir,
I want to transfer the data stored in CSV(comma seperated value) file to Oracle Database table.
Can you guide me how to do this???

Answer
HI Shalabh,

You can use SQL Loader (http://www.oracle.com/technology/products/database/utilities/htdocs/sql_loader_o...) or you can write your own code that parses the CSV file and generate INSERT statements to load into your Oracle database. SQL LOADER is the best for large (bulk) data load.

Here's an FAQ intro for SQL LOADER: http://www.orafaq.com/wiki/SQL*Loader_FAQ

Hope this helps.

Peter

Add to this Answer   Ask a Question


 
User Agreement | Privacy Policy | Kids' Privacy Policy | Help
Copyright  © 2008 About, Inc. AllExperts, AllExperts.com, and About.com are registered trademarks of About, Inc. All rights reserved.