title: Toad for Oracle bind variables with IN clause
body: <p>I have a query that looks like this:</p>
  
  <pre><code>select * from foo where id in (:ids)
  </code></pre>
  
  <p>where the id column is a number.</p>
  
  <p>When running this in TOAD version 11.0.0.116, I want to supply a list of ids so that the resulting query is:</p>
  
  <pre><code>select * from foo where id in (1,2,3)
  </code></pre>
  
  <p>The simple minded approach below gives an error that 1,2,3 is not a valid floating point value.  Is there a type/value combination that will let me run the desired query?</p>
  
  <p><strong>CLARIFICATION</strong>:  the query as shown is how it appears in my code, and I am pasting it into TOAD for testing the results of the query with various values.  To date I have simply done a text replacement of the bind variable in TOAD with the comma separated list, and this works fine but is a bit annoying for trying different lists of values.  Additionally, I have several queries of this form that I test in this way, so I was looking for a less pedestrian way to enter a list of values in TOAD without modifying the query.  If this is not possible, I will continue with the pedestrian approach.</p>
  
  <p><img src="https://i.stack.imgur.com/b0agQ.png" alt="toad variable prompt"></p>