title: Generate .sql script based on .csv file
body: <p>I have for example this table:</p>
  
  <pre><code>table1.csv
      Item;Location;Oftr;OftrPost;Replen
      B01;BI1_p;40;01.05.2015;2
      B02;BI1_p;40;01.05.20
  </code></pre>
  
  <p>I want to generate a .sql external table script. Here's sample:</p>
  
  <pre><code>CREATE TABLE filename*
  (
  row* type*
  row* type*
  row* type*
  ) ORGANIZATION EXTERNAL (
  TYPE ORACLE_LOADER
  DEFAULT DIRECTORY dir_name*
  ACCESS PARAMETERS (
  RECORDS DELIMITED BY NEWLINE
  SKIP 1
  FIELDS TERMINATED BY delimiter*
  MISSING FIELD VALUES ARE NULL
  )
  LOCATION(filename*)
  )
  reject limit unlimited;
  </code></pre>
  
  <p>filename, delimiter, dir_name and row won't be a problem (Few checboxes, readline, path.getiflename). Problem is type*.
  Basically i'll be moving between 3/4 variables - float, number, varchar ,( date if i could do it)
  Question is - How can recognize which column has numeric or float or varchar?
  My first thought was REGEXP, but maybe someone has better idea.</p>