Paramenter list in SQL - to be used as variables with quotes and commas

[Anonymous]

Hello Community,

I have this SQL query for Oracle DB:

SELECT *
FROM
myTables
WHERE
OBS_DATE > (trunc(sysdate) - 365)

AND NAME in (

LIST OF VARIABLES 

)

The LIST of VARIABLES is usually an alphanumeric number and it must have quotes:

for instance:

'PPF000000028300444',

'PPF000000028300334'

I would like to have a Parameter that I can udpate and holds a list of this codes, with commas and quotes.

Therfore, how can I have inside the above query a parameter with my LIST of VARIABLES?

Thank you in advance,

Luca.

[Anonymous · Accepted solution]

So the secret is:

go into edit query -> advance editor -> put in the query NAME in ('"&PARAMETER_NAME&"').

since the parameter is aphanumeric: format such parameter as text.

Done.