You are here:

Oracle/data transfer from CSV file to database.

Advertisement

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

Oracle

All Answers

Answers by Expert:

Ask Experts

Volunteer

Peter Choi

Expertise

I am a senior Oracle DBA, PeopleSoft HCM specialist and Project Manager with 15+ years experience. I have been working with PeopleSoft (HRMS/HCM 5, 7, 7.x and 8.9, 9.x), Oracle RDBMS (7.3 - 11gR2) on various Unix and MS-Windows platforms, and some Oracle Application Server (9i - 11gR1). I also have experience with the configuration and administration of PeopleSoft's Internet Architecture (PIA) and the Oracle 11g Fusion Middleware and Oracle Business Intelligence (OBI).

©2012 About.com, a part of The New York Times Company. All rights reserved.