Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Script for fetching values from excel sheet to sql query

696786Aug 24 2009 — edited Aug 24 2009
I have an excel sheet column which contains names of table .I need to pass this values from excel to a sql query to retrieve the package name which uses this table.
For Eg:
select * from all_source where upper(text) like '%EMP%'
This emp value has been taken from the excel sheet.I want to get the output of all the package names for all tables in single shot.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 21 2009
Added on Aug 24 2009
5 comments
1,221 views