title: How to insert value in table which is not present in input file for sqlldr?
body: <p>Consider the table structure as below:</p>
  
  <pre><code>CREATE TABLE TEST_TABLE
  (
     FIELD_1             VARCHAR2(15) NOT NULL,
     SYS_CREATION_DATE   DATE         NOT NULL,
     FIELD_2             VARCHAR2(25) NOT NULL,
     FIELD_3             VARCHAR2(25)
  )
  </code></pre>
  
  <p>Input file : input.txt - It does not contain SYS_CREATION_DATE it has FIELD_1,FIELD_2,FIELD_3</p>
  
  <pre><code>111111111111111,12345,67890
  </code></pre>
  
  <p>Control file : control.txt</p>
  
  <pre><code>load data
  infile "input.txt"
  append
  into table TEST_TABLE
  fields terminated by ','
  trailing nullcols
  (
     FIELD_1                    ,
     SYS_CREATION_DATE       "SYSDATE",
     FIELD_2            ,
     FIELD_3
  )
  </code></pre>
  
  <p>Now after running</p>
  
  <pre><code>sqlldr userid="uid/pass@ins" control="control.txt"   
  </code></pre>
  
  <p>The below entry is inserted</p>
  
  <pre><code>-------------------------------------------------------------
  | FIELD_1         | SYS_CREATION_DATE   | FIELD_2 | FIELD_3 |
  -------------------------------------------------------------
  | 111111111111111 | 5/9/2017 2:03:03 PM | 67890   |         |
  -------------------------------------------------------------
  </code></pre>
  
  <p>The FIELD_3 is coming in as NULL, I presume this is because the alignment of fields is different in the file and table.</p>
  
  <p>So what can be done to get the entry inserted as below</p>
  
  <pre><code>-------------------------------------------------------------
  | FIELD_1         | SYS_CREATION_DATE   | FIELD_2 | FIELD_3 |
  -------------------------------------------------------------
  | 111111111111111 | 5/9/2017 2:03:03 PM | 12345   | 67890   |
  -------------------------------------------------------------
  </code></pre>