1. PreparedStatement IN clause alternatives? stackoverflow.com
What are the best workarounds for using a SQL
2. java PreparedStatement stackoverflow.com
How to set value for in clause in a preparedStatement in JDBC while executing a query. Example:
If this in-clause can hold multiple values how can ...
3. prepared statement and IN clause coderanch.com
4. PreparedStatement usage in a "NOT IN" clause? coderanch.com
I'm not sure what you mean by the first option. I cannot perform your example using a PS. My query is comething like the following.. select * from employee e where e.status = 'A' and e.emp_id NOT in (?) The ? is dynamically assigned and can be any number of integers, which cannot be performed using PS. Raffi