Can you anyone tell me how to read the first column of Excel file and display the same using PL/SQL?

For example: Excel file contains

Employee id:
1
2
3
4
5

Instead of using the following SQL command in PL/SQL
select * from ps_vendor a
where a.setid = '007' and a.vendor_id in ('1', '2', '3', '4', '5');

I would like to open the excel file read it and provide the same as input in the sql statement.

Any idea??

I moved your thread from Adabas to Oracle. You're much more likely to get useful answers here.

-PatP

How to read Excel from PL/SQL?

Thanks...