SELECT * FROM user_auth WHERE SYSDATE BETWEEN NVL (start_date, SYSDATE - 1) AND NVL (end_date, SYSDATE + 1)
权限区间设置
原文:http://www.cnblogs.com/albert-think/p/6962007.html