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 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
OCP - SQL and PL/SQL
Brainbench certifications in Oracle Administration, PL/SQL, Developer 2000
| | |
| |
You are here: Experts > Computing/Technology > Oracle > Oracle > Csv data into oracle
Oracle - Csv data into oracle
Expert: Suchitra Joshi - 10/22/2009
Question
I want to load data from csv file into oracle database
can u tell me step by step process for this
Answer
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
Add to this Answer Ask a Question
|
|
