Two dates oneDate twoDate, first isn't empty oneDate is used as a query filter conditions, empty twoDate is used as a filter condition, the original use NVL (oneDate twoDate) implementation, low efficiency to change the way now, strives for the big help,