title: Oracle -SQL- Select values based on a long list using where condition
body: <p>I have a long list (over 2000) of phone numbers, and I want to select values where phone numbers are in the list. Can any one tell me how to do it efficiently using sql? Thank you!</p>
  <p>The method I know is :</p>
  <pre><code>select name, date from table where phone in ('8001234567','8011234567',....)
  </code></pre>
  <p>this method lists all the phone numbers in the where condition. Is there any other method, such as I can create a list in some file, then select from the file?</p>
  <p>Thank you.</p>