title: How to get all matching text of IN operator in SQL?
body: <p>To be clear, here is the scenario: I am executing a query like the following:</p>
  
  <p><code>SELECT * FROM table_name WHERE uid IN ( 1, 3, 5, 8, 23, 4, 589 ... )</code></p>
  
  <p>The list of <code>uid</code>s is coming from the user.</p>
  
  <p>Is there a way to get all matching <code>uid</code>s in the list using SQL?</p>
  
  <p>I am looking for Oracle SQL syntax but I also want to know the syntax for common database system.</p>
  
  <p>Thanks.</p>
  
  <p><strong>UPDATE</strong></p>
  
  <p>I want to get <em>ALL MATCHING</em> <code>uid</code>s. For example, in the table there is no record that has a uid <code>8</code> and <code>23</code>, the output should be 1, 3, 5, 4, 589 ...</p>