title: SQL Stored procedure extract data
body: <p>Is this possible in a Oracle 11g SQL stored procedure? I need to get the data base on the <code>list.txt</code> with field ID. 1,3,5 to query in customer table and export the result in result.txt</p>
  
  <p>Table name: <strong>Customer</strong></p>
  
  <pre><code>ID|Name |Country
  1 |Mark |USA
  2 |Allan|UK
  3 |James|USA
  4 |Todd |UK
  5 |Mike |UK
  </code></pre>
  
  <p>File: <strong>list.txt</strong></p>
  
  <pre><code>ID
  1
  3
  5
  </code></pre>
  
  <p>Result exported in text file</p>
  
  <p><strong>result.txt</strong></p>
  
  <pre><code>1 |Mark |USA
  3 |James|USA
  5 |Mike |UK
  </code></pre>