title: Update query if statement for Oracle
body: <p>I need to update newly created column in my oracle table. To do so I need to use existing values in row to decide how to populate this column, I am getting error:</p>
  
  <pre><code>java.lang.NullPointerException -&gt; See Debug Output for details
  </code></pre>
  
  <p>This is my query:</p>
  
  <pre><code>UPDATE
      SCHEMA_NAME.TABLE_NAME
  SET
      OCO= IF CO= 'Y' AND COM='Y' THEN 
  {
      'Y'
  } ELSE
  {
      'N'
  }
  END IF;
  </code></pre>
  
  <p>Any suggestions on syntax?</p>