DYNAMIC VALUE FILL IN Oracle query

Question

SELECT ID,PAYMENT_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 · Accepted 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 ID,PAYMENT_RECEIVE_DATE FROM PAYMENT_DETAILSWHERE P_ID IN(" + s +")";

Sompal Arya · Answer

Thanks a lot Sir...