title: oracle external table with date column and skip header
body: <p>I have a file,</p>
  
  <pre><code>ID,DNS,R_D,R_A
  1,123456,2014/11/17,10
  2,987654,2016/05/20,30
  3,434343,2017/08/01,20
  </code></pre>
  
  <p>that I'm trying to load to oracle using External Tables. <strong>I have to skip the header row and also load the date column.</strong></p>
  
  <p>This is my query:</p>
  
  <pre><code>DECLARE
  FILENAME VARCHAR2(400);
  BEGIN
  FILENAME := 'actual_data.txt';
  EXECUTE IMMEDIATE 'CREATE TABLE EXT_TMP (
    ID      NUMBER(25),
    DNS  VARCHAR2(20),
    R_D DATE,
    R_A  NUMBER(25)
  )
  ORGANIZATION EXTERNAL (
    TYPE ORACLE_LOADER
    DEFAULT DIRECTORY USER_DIR
    ACCESS PARAMETERS (
      RECORDS DELIMITED BY NEWLINE
      FIELDS TERMINATED BY '',''
      MISSING FIELD VALUES ARE NULL
      SKIP 1
      (
    "ID",      
    "DNS",
    "R_D" date "dd-mon-yy",
    "RECHARGE_AMOUNT"
      )
    )
    LOCATION (''' || FILENAME || ''')
  )
  PARALLEL 5
  REJECT LIMIT UNLIMITED';
  END;
  </code></pre>
  
  <p>I get following exception:</p>
  
  <pre><code>ERROR at line 1:
  ORA-29913: error in executing ODCIEXTTABLEOPEN callout
  ORA-29400: data cartridge error
  KUP-00554: error encountered while parsing access parameters
  KUP-01005: syntax error: found "skip": expecting one of: "column, exit, (,
  reject"
  KUP-01007: at line 4 column 5
  ORA-06512: at "SYS.ORACLE_LOADER", line 19
  </code></pre>
  
  <p>I'm using sqlplus.</p>
  
  <p>Could some oracle veterans please help me out and tell me what I'm doing wrong here? I'm very new to oracle.</p>