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
gaju_3112
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)?

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

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

http://www.astral-consultancy.co.uk/cgi-bin/hunbug/doco.cgi?11210

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


Current Time: Thu Dec 05 17:19:59 CST 2024