Home » Developer & Programmer » Application Express, ORDS & MOD_PLSQL » csv from htmldb_application_files to table
csv from htmldb_application_files to table [message #183326] Thu, 20 July 2006 06:51 Go to next message
tom01
Messages: 29
Registered: July 2006
Junior Member
Hi,

Can anybody help me with procedure which copies data from csv file (stored in HTMLDB_APPLICATION_FILES) to table in database? This table has the same structure as csv file, I mean the same columns etc.

I'm new to pl/sql and oae and I can't make it.

I would really appreciate some help(code/link/advice).

Thanks in advance!
Tom
Re: csv from htmldb_application_files to table [message #183327 is a reply to message #183326] Thu, 20 July 2006 06:55 Go to previous messageGo to next message
navkrish
Messages: 189
Registered: May 2006
Location: NJ,USA
Senior Member

To copy data from csv file to table, you can use sql loader utility..

Naveen
Re: csv from htmldb_application_files to table [message #183328 is a reply to message #183327] Thu, 20 July 2006 06:58 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
Ooo, bad luck on getting exiled to the outer darkness.....

You could do it by creating an external table
Previous Topic: xls to csv convertion (not 'Save as...')
Next Topic: Upload file button
Goto Forum:
  


Current Time: Fri Mar 29 08:33:36 CDT 2024