Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
?
Solved

How  to read  data in an excel sheet in a Oracle pl/SQL procedure.

Posted on 2008-10-20
4
Medium Priority
?
935 Views
Last Modified: 2013-12-18
I need urgently PL/SQL code to read data from an Excel sheet Using an Oracle 10g pl/SQL procedure. The input file is .xls and not any other format. Kindly help me in this regard as this is a required very urgently.
0
Comment
Question by:Swaminathan_K
2 Comments
 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 2000 total points
ID: 22759577
You need to export first to a csv file and then create external table on the file.
 
 
0
 

Author Comment

by:Swaminathan_K
ID: 22764295
Is there any way to read a excel file rather then converting it intoa CSV file
0

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Working with Network Access Control Lists in Oracle 11g (part 2) Part 1: http://www.e-e.com/A_8429.html Previously, I introduced the basics of network ACL's including how to create, delete and modify entries to allow and deny access.  For many‚Ķ
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
This video shows how to configure and send email from and Oracle database using both UTL_SMTP and UTL_MAIL, as well as comparing UTL_SMTP to a manual SMTP conversation with a mail server.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.

577 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question