oracle nvl

SELECT h.location_id, h.location_code, h.cust_province
  FROM apps.cop_customer_header_v h
WHERE nvl(h.location_id,-1) IN (-1)
 --WHERE  h.location_id IN (1,2,3) OR h.location_id IS NULL

 

SELECT *
  FROM cop_location_auth
 WHERE person_id = 8745
      --AND location_id=4
   AND SYSDATE BETWEEN NVL(start_date, SYSDATE - 1) AND
       NVL(end_date, SYSDATE + 1)

转载于:https://www.cnblogs.com/albert-think/p/6055139.html