Home » SQL & PL/SQL » SQL & PL/SQL » how to upload excel file using pl/sql
how to upload excel file using pl/sql [message #188221] Thu, 17 August 2006 08:26 Go to next message
jilhewar_santosh
Messages: 13
Registered: July 2006
Location: mumbai
Junior Member
hi,
i have excel file and i want upload this excel file into oracle
table using pl/sql procedure so i need pl/sql code for same
Re: how to upload excel file using pl/sql [message #188230 is a reply to message #188221] Thu, 17 August 2006 08:35 Go to previous message
JRowbottom
Messages: 5933
Registered: June 2006
Location: Sunny North Yorkshire, ho...
Senior Member
You'll want to export the XLS to a CSV, and then either use SQlLdr or External tables.

Excel files are a proprietry format, and not easliy readable.
Previous Topic: Parent/Child Request trying to incombaitibly lock object
Next Topic: Complex query on hierarchy
Goto Forum:
  


Current Time: Sat Dec 03 09:41:54 CST 2016

Total time taken to generate the page: 0.14432 seconds