OraFAQ Forum: Forms » Loading .csv file into oracle database using PL/SQL

Home » Developer & Programmer » Forms » Loading .csv file into oracle database using PL/SQL

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Loading .csv file into oracle database using PL/SQL [message #267961]

Sun, 16 September 2007 23:32

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?

Report message to a moderator

Re: Loading .csv file into oracle database using PL/SQL [message #267964 is a reply to message #267961]

Sun, 16 September 2007 23:59

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

Report message to a moderator

Re: Loading .csv file into oracle database using PL/SQL [message #267979 is a reply to message #267961]

Mon, 17 September 2007 01:11

gaju_3112
Messages: 28
Registered: September 2007
Location: India

Junior Member

Can I do it using SQL *plus only?

Report message to a moderator

Re: Loading .csv file into oracle database using PL/SQL [message #267982 is a reply to message #267979]

Mon, 17 September 2007 01:18

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

You have posted this in Forms forum.
Please don't cross post.

Vamsi

Report message to a moderator

Re: Loading .csv file into oracle database using PL/SQL [message #267991 is a reply to message #267979]

Mon, 17 September 2007 01:50

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:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Sep 04 23:07:29 CDT 2025