title: Using NVL in where clause for a parameter
body: <p>Right now I have the following query:</p>
  
  <pre><code>select INVOICE_ID, INVOICE_NUM, VENDOR_NUM, STATUS, GROUP_ID
  from AP_INVOICES_INTERFACE 
  and status in(:p_status)
  and last_update_date between :p_date_from and :p_date_to
  order by last_update_date, group_id
  </code></pre>
  
  <p>But this only shows if the status is either 'rejected' or 'processed'. I need it so that it also shows when the status is null. How would I include NVL to show this?</p>
  
  <p>Not sure if this information is relevant but the list of values for Status has the query as</p>
  
  <pre><code>SELECT DISTINCT STATUS 
  FROM AP_INVOICES_INTERFACE
  </code></pre>