Passing the Parameter to SQL
I have a SQL query that has list of Trx Numbers listed in WHERE clause and using IN comparison on it, here user want to enter the list of parameters by comma separated.
Ex :- select * from ra_Customer_Trx_all where trx_number in (:Trx_Number) .
here for Trx_number have to pass multiple parameters at a time.
Please help me how to achieve this.
Thanks in advance !