权限区间设置
SELECT *
FROM user_auth
WHERE
SYSDATE BETWEEN NVL (start_date, SYSDATE - 1)
AND NVL (end_date, SYSDATE + 1)
SELECT *
FROM user_auth
WHERE
SYSDATE BETWEEN NVL (start_date, SYSDATE - 1)
AND NVL (end_date, SYSDATE + 1)