Like as code below I’d like to delete dynamic number of Ids from a table by using name query and I’d like to pass the ids list as params but I can’t figure it out how to pass a list to name query.
DELETE FROM dependents
WHERE
employee_id IN (100 , 101, 102);
You can’t do it in a named query. You need to dynamically construct a “Prep” query in a script (with the correct number of question marks) to do this with safe parameters.