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 (???)