Home » SQL & PL/SQL » SQL & PL/SQL » Import CSV without SQL*LOADER (ORACLE 10g)
Import CSV without SQL*LOADER [message #303520] Fri, 29 February 2008 12:43 Go to next message
Messages: 93
Registered: March 2007
I am trying to import a CSV using

load data
 infile '$local_file'
 fields terminated by "," optionally enclosed by '"'		  
 ( empno, empname, sal, deptno )

However I do not want to call SQL*LOADER as I am running the SQL using PHP.

IS this possible?
Re: Import CSV without SQL*LOADER [message #303522 is a reply to message #303520] Fri, 29 February 2008 12:47 Go to previous message
Messages: 7880
Registered: March 2000
Senior Member
Use an external table
Previous Topic: Comparing fields?
Next Topic: pl/sql program for table updation
Goto Forum:

Current Time: Tue Oct 25 07:12:54 CDT 2016

Total time taken to generate the page: 0.08971 seconds