Skip to content
Advertisement

How to pass in a comma separated list of values as a Parameter input in Oracle

I have a simple select query that I would like to pass in a Parameter in the WHERE clause which contains more than one value, (comma separated list) and the query shows results for each comma separated value ? I need to know what the syntax / method for this is in Oracle SQL.

So in the Query below my Parameter is (:ENTITY_CODE) and I want this parameter to pass in a comma separated list of values

Advertisement

Answer

You can use hierarchy query as follows:

User contributions licensed under: CC BY-SA
8 People found this is helpful
Advertisement