DYNAMIC VALUE FILL IN Oracle query

Question

SELECT IDPAYMENT_RECEIVE_DATE FROM PAYMENT_DETAILS WHERE P_ID IN( '23''2''2''4''5''7' ) I have to dynamic fill values of P_ID.My main PROBLEM is that P_ID can up to 100 or more or can be 2 or 3 i do not want to fill through array . i do not want to use array[200]. Plaese suggest me solution...so that i fill P_ID .... Thanks in advance

Vulpes · Answer

Well first of all I'd place your integer IDs in a List rather than an array. You can then add only a few or a lot of integers as you please. With the help of a bit of LINQ you can then easily build your SQL query: using System.Collections.Generic; using System.Linq; //.... var list = new List {23 2 2 4 5}; list.Add(7); // add as many other integers as you like var query = list.Select(i => ' + i + '); string s = String.Join( query.ToArray()); string sql = SELECT IDPAYMENT_RECEIVE_DATE FROM PAYMENT_DETAILSWHERE P_ID IN( + s +);

Sompal Arya · Answer

Thanks a lot Sir...