Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » Converting .csv into oracle database
Converting .csv into oracle database [message #267958] Sun, 16 September 2007 23:21 Go to next message
Messages: 28
Registered: September 2007
Location: India
Junior Member

I have .csv file in which all records are lying. Can anybody tell me PL/SQL code for reading these records and inserting it into database?
Re: Converting .csv into oracle database [message #267959 is a reply to message #267958] Sun, 16 September 2007 23:25 Go to previous messageGo to next message
vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH
Senior Member
Do you have any problem in using SQL*Loader (or) External Tables(from 9i)?

Re: Converting .csv into oracle database [message #269056 is a reply to message #267958] Thu, 20 September 2007 10:39 Go to previous message
Messages: 22
Registered: October 2006
Location: UK
Junior Member

This link may be useful if you are able to use External Tables to access your csv file.


Hope this helps
Previous Topic: Import to Oracle from Excel .XLS files- it there a way?
Next Topic: Oracle GUI coding and information
Goto Forum:

Current Time: Mon Jul 04 10:51:54 CDT 2022