Hi, I am writing an sql query where I want to pass no. of values to IN but I don't know how many values may come during run time.
for eg.
- SELECT * FROM WHERE EMP_NAME IN ('ABC', 'XYZ', 'PQR')
- SELECT * FROM WHERE EMP_NAME IN ('ABC', 'XYZ', 'PQR', 'VWX', 'STY', DEF')
- SELECT * FROM WHERE EMP_NAME IN ('ABC', 'XYZ', 'PQR', 'IWX', 'NAP', 'FPE', 'DEQ', 'RRLY' )
so in first query IN is having only 3 values, in 2nd 5 values and in 3rd we have 8 values, values in IN are not fixed, it may vary, how would I handle it?
Please help.