SQL Language (MOSC)

MOSC Banner

Passing the Parameter to SQL

edited February 2023 in SQL Language (MOSC) 11 commentsAnswered

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 !

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center