title: read from all files in a folder to external tables oracle
body: <p>I wrote an sql statement like this:</p>
  
  <pre><code> CREATE TABLE TableA 
     (    "Col1" VARCHAR2(5 BYTE), 
      "Col2" VARCHAR2(2 BYTE), 
  
     ) 
     ORGANIZATION EXTERNAL 
      ( TYPE ORACLE_LOADER
        DEFAULT DIRECTORY "DIR"
        ACCESS PARAMETERS
        ( records delimited by newline
  fields terminated by ','
  optionally enclosed by '"'
      )
        LOCATION
         ( 'TableA.csv'
         )
      )
     REJECT LIMIT UNLIMITED ;
  </code></pre>
  
  <p>There are 120 .csv files in my 'DIR' directory. I need to read in each of the file and create separate external tables for each file. For example tableA has to be created for fileA. 
  Is it possible to write a procedure for this, reading each filename into a loop and substituting the filename variable into the above sql state and running the sql statement within the loop?</p>