title: export multiple table data into csv file in oracle
body: <p>I  have five different tables as a,b,c,d,e with different number of columns.
  I want to export the data into the csv file from all this five table.
  In common i have seq_no in all five tables.seq_no wise file should get generated.</p>
  
  <p>And </p>
  
  <pre><code>table a data should be row 1
  
  table b data should be row 2
  
  table c data should be row 3
  
  table d data should be row 4
  
  table d data should be row n    
  
  table e data should be row n+1
  </code></pre>
  
  <p>In table a,b,c,e only 1 record will be there for 1 seq_no</p>
  
  <p>In table d multiple records will be there for 1 seq_no.</p>
  
  <p>E.G</p>
  
  <p>Seq_no = 1 then only that data should get exported to the csv.</p>
  
  <p>seq_no = 2 then only that data should get exported to the csv</p>
  
  <p>..... etc</p>
  
  <p>if count(seq_no) = 10 then 10 files should get exported. </p>
  
  <p>how can i achive this through plsql function/procedure?</p>