title: oracle external table get selected columns from the file
body: <p>I'm having problems with oracle external table I have a text file will 50+ unnecessary columns, Now I want to select a few columns from the text file to my external table.</p>
  
  <pre><code>        create table tmpdc_ticket(
          SERVICE_ID CHAR(144),
          SERVICE_TYPE CHAR(50),
          CUSTOMER_NAME CHAR(200),
          TELEPHONE_NO CHAR(144),
          ACCOUNT_NUMBER CHAR(144),
          FAULT_STATUS CHAR(50),
          BUSINESS_GROUP CHAR(100)
      )
      organization external(
          type    oracle_loader
          default directory sample_directory
          access parameters(
              records delimited by newline
              nologfile
              skip 1
              fields terminated by '|'
              missing field values are null
                  (SERVICE_ID CHAR(144),
                   SERVICE_TYPE CHAR(50),
                   CUSTOMER_NAME CHAR(200),
                   TELEPHONE_NO CHAR(144),
                   ACCOUNT_NUMBER CHAR(144),
                   FAULT_STATUS CHAR(50),
                   BUSINESS_GROUP CHAR(100)
              )
          )
          location(sample_directory:'sample_file.txt')
      )
      reject limit 1
      noparallel
      nomonitoring;
  </code></pre>
  
  <p>However it seems like the oracle_loader is doing inserting from the first column from my textfile. Is it possible to get already like for example the 3rd columns from the textfile?</p>