Home » Developer & Programmer » Forms » Loading .csv file into oracle database using PL/SQL
Loading .csv file into oracle database using PL/SQL [message #267961] Sun, 16 September 2007 23:32 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: Loading .csv file into oracle database using PL/SQL [message #267964 is a reply to message #267961] Sun, 16 September 2007 23:59 Go to previous messageGo to next message
shakti_goyal
Messages: 60
Registered: November 2006
Location: India
Member

If you are using Developer 2000 then you can use Text_io Package to load the .csv file in to database.
You need to write a filehandler in a procedure and then explicitly write the insert command that will load the data in tables.

Shakti
Re: Loading .csv file into oracle database using PL/SQL [message #267979 is a reply to message #267961] Mon, 17 September 2007 01:11 Go to previous messageGo to next message
gaju_3112
Messages: 28
Registered: September 2007
Location: India
Junior Member

Can I do it using SQL *plus only?
Re: Loading .csv file into oracle database using PL/SQL [message #267982 is a reply to message #267979] Mon, 17 September 2007 01:18 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
You have posted this in Forms forum.
Please don't cross post.

Vamsi
Re: Loading .csv file into oracle database using PL/SQL [message #267991 is a reply to message #267979] Mon, 17 September 2007 01:50 Go to previous message
shakti_goyal
Messages: 60
Registered: November 2006
Location: India
Member

You can also use SQl*Loader for this purpose.

Shakti

[Updated on: Mon, 17 September 2007 01:52]

Report message to a moderator

Previous Topic: how i can make text item read only
Next Topic: dynamic grid problem
Goto Forum:
  


Current Time: Thu Dec 08 00:40:00 CST 2016

Total time taken to generate the page: 0.06954 seconds