Need Asistance Uisng Bind Variable within SQL
I am trying to figure out how to use a bind variable in the "Where -NOT IN" clause when the bind varialbe needs to be a list of numbers
id defined as number(10)
original sql:
select
id,
name
from
test_table
where
id NOT IN (10888955,11138235,11138236,27731942,27732162)
order by
name;
needed sql using bind variable:
select
id,
name
from
test_table
where
id NOT IN (:v_ids)
order by
name;
How would I define the list using a bind variable (:v_ids) or can I ?
Thanks
Jim