title: Oracle WHERE clause ( AND , OR operators)
body: <p>Friends 
  while executing where clause in Oracle SQL suppose  I have </p>
  
  <pre><code>UPDATE schema1.TBL_SCHEMA1_PROCESS_FEED F
                   SET F.TBL_SCHEMA1_PROCESS_LINE_ID      = V_LINE_ID,
                       F.TBL_SCHEMA1_PROCESS_LINE_TYPE_ID = V_LINE_TYPE_ID,
                       F.TBL_SCHEMA1_PROCESS_LINE_SUB_TYPE_ID = V_SUB_TYPE_ID,
                 WHERE F.CURR_DATE = V_CURR_DATE  
                 AND   F.NEXT_DATE = V_NEXT_BUSINESS_DATE OR F.NEXT_DATE IS NULL;
  </code></pre>
  
  <p>How this code can be optimized for the condition </p>
  
  <pre><code>F.NEXT_DATE = V_NEXT_BUSINESS_DATE OR F.NEXT_DATE IS NULL
  </code></pre>