title: ORACLE substitute variable in IN statement
body: <p>I have simple query like </p>
  
  <pre><code>SELECT * FROM temp t WHERE t.id IN (:IDs)
  </code></pre>
  
  <p>When executed, it prompts me (Oracle SQL Developer) for entering value if IDs variable.</p>
  
  <p>When I enter for example 169, everything runs smoothly, but when I try to enter multiple IDs, like 169,170,171, I get error Invalid Number even while putting it into ''.</p>
  
  <p>I'm used to working with MS SQL and MySQL, so this is little confusing to me.</p>
  
  <p>Anyone any suggestions.</p>