title: Can variables be passed to a SQL*Loader control file via sqlldr command?
body: <p>Below is my Control file example : </p>
  
  <pre><code>    OPTIONS (skip=1,errors=1000,direct=true,rows=10000)
      load data 
      append
      into table TABLE_NAME
      fields terminated by ','
      OPTIONALLY ENCLOSED BY '"'
      trailing nullcols(
        DATE_ID       DATE_ID_VALUE,
        DESC1         char(1000),
        DESC2         char(1000),
        DISP_URL      char(1000),
        DEST_URL      char(1000),
        ACCT_ID       ACCOUNTID_VALUE,
        Acct_num      ACCOUNT_NUM,
        created_date SYSDATE
      )
  </code></pre>
  
  <p>I need to pass DATE_ID_VALUE,ACCOUNTID, ACCOUNTNUM values from sqlldr command. Am passing the remaming columns data via csv file which inturn is passed from sqlldr "DATA" parameter. Is there a way to pass other required parameters via sqlldr command or any other way to do it?</p>
  
  <p>Below is my sqlldr command : </p>
  
  <pre><code>   sqlldr userid=abc/abcdef@abcdefgh CONTROL= cont.ctl DATA= $csvFilePath  LOG=admaster.log BAD=admaster.bad
  </code></pre>