title: NESTED IF's in PL/SQL
body: <p>I am trying to write nested IFs in a pl/sql block. How do I arrange properly.</p>
  
  <pre><code>IF r1.CABLE_TYPE = "A" THEN
  var_root = FC_CPSCBPR1.C_111_SCPSCBP
  </code></pre>
  
  <p>Logic I have to include now </p>
  
  <pre><code>If var_root is "TRUE" /*If the value is populated*/
    THEN 
         IF ...
              THEN
  Elsif var_root is "FALSE" /*If the value is not found*/
  
        THEN
  </code></pre>