title: How to use 2 different selects depending on an item value?
body: <p>I'm new to PL/SQL and Oracle. Is there a way to do 2 different selects, depending on the value of an APEX item? </p>
  
  <p>For example:</p>
  
  <pre><code>IF :item IS NULL
      THEN select abc from d where row1 = 2
  ELSE
      select zzz from b where row2 = 2
  </code></pre>
  
  <p>Is there a simple way to do this just using Oracle SQL and not even using PL/SQL?</p>