OraFAQ Forum: Application Express, ORDS & MOD_PLSQL » Converting .csv into oracle database

Sun, 16 September 2007 23:21

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?

Sun, 16 September 2007 23:25

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

Thu, 20 September 2007 10:39

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: Sat Jun 12 21:56:34 CDT 2021