select * from table where comumn in (string)?

[nzcam]

Hi,

I have a select statement that is currently doing this

Select *
from product
where product_reference in ('prod1','prod2');

What I would like to do is change the ('prod1','prod2') to a single string (or even better an array ) that holds all the product codes that I require?

can anyone help?

Thanks

cam

 

[saketbansal]

Several Options

1. Use Dynamic cursor , so u can make ur full statement in string and opem it later

2. make a function which checks the prod_reference in array

Select *
from product
where if_exists(product_reference, array) =1

so the function if exists can be

function if_exists ( ar_prod, array) return number
as
begin
--search the ar_prod in array and return 1 if found else ----return 0
end ;