Sompal Arya

Sompal Arya

  • NA
  • 286
  • 50.3k

DYNAMIC VALUE FILL IN Oracle query

Mar 22 2014 8:42 AM
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

Answers (2)