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
Messages: 13
Registered: July 2006
Location: mumbai
Junior Member
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
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: Wed Jul 26 15:55:02 CDT 2017

Total time taken to generate the page: 0.17874 seconds