title: import csv file into table using SQL Loader [but large no. of Columns]
body: <p>I want to import data in the form of csv file into a table.[using Oracle SQL developer].I have such hundred files and each has about 50 columns.</p>
  
  <p>From the wiki of SQL*Loader (http://www.orafaq.com/wiki/SQL*Loader_FAQ) </p>
  
  <pre><code> load data
   infile 'c:\data\mydata.csv'
   into table emp
   fields terminated by "," optionally enclosed by '"'          
   ( empno, empname, sal, deptno )  //these are the columns headers
  </code></pre>
  
  <p>What i don't want to do is list down all the column headers.I just want all the enteries in the csv file to be assigned to members in the tables in the order in which they appear.</p>
  
  <p>Moreover after all think i want to automate it for all the 100 files.</p>