title: How to use the OR condition in when clause of SQL Loader control file
body: <p>I am trying to use the OR condition in when clause in control file, This this my code in control file :</p>
  
  <pre><code>load data
  INFILE 'router.txt'
  INTO TABLE ROUTER_ATTLAS_TABLENAME  
  APPEND
  **WHEN ((1) = 'J' or  (1) = 'D2'  or  (1) = 'vJ' or  (1) = 'VJ' )**
  FIELDS TERMINATED BY '\|'
  </code></pre>
  
  <p>I am getting a error :SQL*Loader-350: Syntax error at line 5.</p>
  
  <pre><code>Expecting ")", found "or".
  WHEN ((1) = 'J' or  (1) = 'D2'  or  (1) = 'vJ' or  (1) = 'VJ' )
  </code></pre>
  
  <p>Please suggest me an  correct syntax.</p>