How can we enter many values in a SQL parameter - SQL Developer?

In SQL Developer, we can use parameters in order to test our query with different values - for example:

I have a table called Fruits (code, name). I want to retrieve code's apples.

SELECT *
FROM fruits
WHERE name IN PM_NAME)


It works correctly when I fill out one value (in this case M_NAME equal apple)



But when I want to fill out many values it doesn't work! I've tried these forms and these separators but still..

apple;orange

'apple';'orange'

('apple','orange')

['apple','orange']

"apple","orange"




In a nutshell what's the correct format to fill out multiple values in a SQL parameter in SQL Developer ?

Continue reading...