Home » SQL & PL/SQL » SQL & PL/SQL » Import CSV using PHP or PL/SQL
Import CSV using PHP or PL/SQL [message #246296] Wed, 20 June 2007 09:53 Go to next message
hdogg
Messages: 93
Registered: March 2007
Member
My end goal is to import and excel CSV file into my oracle database.

I've been searching and searching for the way to do this. Does anybody have any links that uses the php - oracle - csv file import?

-Hyrum
Re: Import CSV using PHP or PL/SQL [message #246299 is a reply to message #246296] Wed, 20 June 2007 09:57 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
SQL*LOADER (sqlldr) is designed to load CSV files into Oracle.
Re: Import CSV using PHP or PL/SQL [message #246317 is a reply to message #246296] Wed, 20 June 2007 10:42 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Or external table to see your file as a table.

Regards
Michel
icon7.gif  Re: Import CSV using PHP or PL/SQL [message #246329 is a reply to message #246296] Wed, 20 June 2007 11:26 Go to previous messageGo to next message
ksoule
Messages: 13
Registered: November 2003
Location: Austin, TX
Junior Member
This could be helpfull.

http://www.oracle.com/technology/products/database/utilities/htdocs/sql_loader_overview.html

An example of how to use sql loader

http://orafaq.com/faqloadr.htm

Good luck
Re: Import CSV using PHP or PL/SQL [message #246349 is a reply to message #246296] Wed, 20 June 2007 12:45 Go to previous messageGo to next message
hdogg
Messages: 93
Registered: March 2007
Member
Thanks for the help... it is the same that have gotten from researching... the problem i have is that when i enter sqlldr and/or sqlload SQL*PLUS doesnt recognize the commands
Re: Import CSV using PHP or PL/SQL [message #246352 is a reply to message #246296] Wed, 20 June 2007 12:56 Go to previous messageGo to next message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
Too bad you have not read or followed the posting guidelines as stated in the STICKY posts at the top of this forum.
Effectively what you told us is.
My car won't go.
Tell me how to make my car go.

Without additional details, You're On Your Own (YOYO)!

[Updated on: Wed, 20 June 2007 12:56] by Moderator

Report message to a moderator

Re: Import CSV using PHP or PL/SQL [message #246353 is a reply to message #246349] Wed, 20 June 2007 12:57 Go to previous messageGo to next message
ksoule
Messages: 13
Registered: November 2003
Location: Austin, TX
Junior Member
execute sqlldr or sqlldr80 from the dos cmd prompt if you have MSWindows. From sqlplus you have to do : host "sqlldr".

Follow all the steps to call sqlldr correcttly; create a datafile,control file , log file etc...

Good luck
Re: Import CSV using PHP or PL/SQL [message #246354 is a reply to message #246349] Wed, 20 June 2007 12:57 Go to previous messageGo to next message
Michel Cadot
Messages: 64132
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Verify that ORACLE_HOME is set.
Veriry that your PATH contains ORACLE_HOME/bin.

Regards
Michel
Re: Import CSV using PHP or PL/SQL [message #246356 is a reply to message #246296] Wed, 20 June 2007 13:05 Go to previous message
BlackSwan
Messages: 25046
Registered: January 2009
Location: SoCal
Senior Member
hdogg,
OS name & version
Oracle version to 4 decimal place -> here is to hoping that some Oracle s/w is already installed.
Previous Topic: i am so lazy, i cannot come up with a good title
Next Topic: max salary
Goto Forum:
  


Current Time: Thu Dec 08 00:39:01 CST 2016

Total time taken to generate the page: 0.18387 seconds