title: Selecting static values to union into another query
body: <p>Essentially, my problem is that I need to run a query in Oracle that unions a static list of values ('Static' meaning it's obtained from somewhere else that I cannot get from the database, but is actually an arbitrary list of values I plug into the query) with a dynamic list of values returned from a query.</p>
  
  <p>So, my initial query looks like:</p>
  
  <pre><code>select * from (select ('18776') as instanceid from dual) union (&lt;more complex query&gt;)
  </code></pre>
  
  <p>I think, hooray!  And then try to do it with a longer list of static values.  Turns out, I get 'Missing Right Parenthesis' if I try to run:</p>
  
  <pre><code>select ('18776','18775') as instanceid from dual
  </code></pre>
  
  <p>So, my basic issue is how can I integrate a list of static values into this union?</p>
  
  <p>NOTE: This is a simplified example of the problem.  The actual list is generated from an API before I generate a query, and so this list of "static" values is unpredictably and arbitrarily large.  I'm not dealing with just 2 static values, it is an arbitrary list.</p>