title: If (multiple condition) ... else
body: <p>I have a if else statement with two conditions has to meet by the first "IF". But I couldn't make it work and with not one but few syntax errors. Appreciated if any of you could help. </p>
  
  <p>Here is how I wrote the code:</p>
  
  <pre><code>Declare 
      is_null Integer := 10;
      Wrong_record :=2;
  
  If (is_null &gt; 0 or wrong_record &gt; 0 )
  Begin
  
  Insert INTO table name (column1, column2, .......)
  Values
      ( value1, value2,........);
  
  ElSE
  
      Insert INTO table name (column1, column2, .......)
     Values
      ( value1, value2,........);
  END IF;
  END
  </code></pre>