title: Multiple values in parameters- SQL(Oracle)
body: <p>I want to pass multiple values via a single parameter.</p>
  
  <hr>
  
  <pre><code>select 
  id,
  item_number 
  from AGILE.item_p2p3_query where subclass='2477110' and date32 is not null 
  and item_number in : p **// passing one parameter would work. But when I pass two parameters like EN 60439-1:1999,EN 60439-3:1991 doesn't seem to work**
  --in ('EN 60439-3:1991','EN 60439-1:1999') // this will work
  </code></pre>
  
  <hr>
  
  <p>Kindly suggest only SQL suggestion and not PL/SQL as I would be using this in a report.</p>