Solved

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

Posted on 2008-10-20
4
926 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
4 Comments
 
LVL 29

Accepted Solution

by:
MikeOM_DBA earned 500 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

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

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

Truncate is a DDL Command where as Delete is a DML Command. Both will delete data from table, but what is the difference between these below statements truncate table <table_name> ?? delete from <table_name> ?? The first command cannot be …
Cursors in Oracle: A cursor is used to process individual rows returned by database system for a query. In oracle every SQL statement executed by the oracle server has a private area. This area contains information about the SQL statement and the…
Via a live example, show how to restore a database from backup after a simulated disk failure using RMAN.
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.

943 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

Need Help in Real-Time?

Connect with top rated Experts

6 Experts available now in Live!

Get 1:1 Help Now