I am writing a sql script for which i want to pass parameters and run that sql script. For ex:
select * from dept where deptno in (10,20,30,40);
i want to pass 10,20,30,40 as parameters to the sql script that is written. How can i write the query and pass the parameters to the above query.