title: How to fetch the data from multiple tables using pl/sql
body: <p>I am having the 10 tables for 10 countries. Each table having the two same columns for all countries.</p>
  
  <p>I want to fetch the data from 10 tables at a time and fetched data should saved in text file. i.e each table data should be saved in each text file.</p>
  
  <p>Below is the table description. same for all tables.</p>
  
  <pre><code>   Name                                     Null?    Type
  
  MSISDN                                    NOT NULL   VARCHAR2(25)
  GREET_FILE_NAME                                      VARCHAR2(100)
  </code></pre>
  
  <p>Kindly help me to make this. thanks in advance.</p>