Pass a huge dataset to a query I have a huge set of employee ids (1000 to 10000) which I can't pass through IN clause. I don't want to use a Global Temporary table since I don't have write access in the DB (only read access). 

What is the best way to pass the data to the query?

SELECT EMPLOYEE_NAME,AGE,SALARY 
from EMPLOYEE 
WHERE EMPLOYEE_ID IN (???)
After some digging around it does seem like write access can be granted but the constraint here is there should be no leftovers i.e no empty temp table lying around after the transaction is done.

Going with the temp table solution and dropping it at the end of the transactions.