title: Oracle PL\SQL Null Input Parameter WHERE condition
body: <p>As of now I am using IF ELSE to handle this condition</p>
  
  <pre><code>IF INPUT_PARAM IS NOT NULL
  
      SELECT ... FROM SOMETABLE WHERE COLUMN = INPUT_PARAM
  ELSE
      SELECT ... FROM SOMETABLE
  </code></pre>
  
  <p>Is there any better way to do this in a single query without IF ELSE loops. As the query gets complex there will be more input parameters like this and the amount of IF ELSE required would be too much.</p>