You are here:
- Home
- Computing/Technology
- Oracle
- Oracle
- Csv data into oracle
Oracle/Csv data into oracle
Advertisement
Question
I want to load data from csv file into oracle database
can u tell me step by step process for this
Hi San,
You will have to use SQL*Loader to load csv file to Oracle tables.
For this you will have to create a control file, which is entirely dependent on your csv file format.
So if you can send me the CSV file format and your Oracle table structure, I can assist you in creating the control file and send you the commands to load this.
You can find all the information of SQL*Loader at this site -
http://www.orafaq.com/wiki/SQL*Loader_FAQ
Hope this helps.
Regards
Suchitra
Related Articles
Oracle
Suchitra Joshi
Expertise
I can answer questions regarding SQL, PL/SQL, Procedures, Functions, Triggers, SQL Loader, Oracle Forms, Oracle Reports, and some basic dba and performance tuning activities.
Experience
15+ years of Oracle PL/SQL Development
Education/Credentials
B.Sc (Electronics), Diploma in Computer Applications (DCA)
Awards and Honors
Oracle PL/SQL Developer Certified Associate (OCA)
Oracle Database: SQL Certified Expert
Brainbench certifications in Oracle Administration, PL/SQL, Developer 2000
©2012 About.com, a part of The New York Times Company. All rights reserved.