select *
from per_all_people_f papf
where trunc(sysdate) between trunc(papf.effective_start_date) and
trunc(papf.effective_end_date)
and papf.employee_number = 145;
转载于:https://www.cnblogs.com/rigid/p/4153902.html
select *
from per_all_people_f papf
where trunc(sysdate) between trunc(papf.effective_start_date) and
trunc(papf.effective_end_date)
and papf.employee_number = 145;
转载于:https://www.cnblogs.com/rigid/p/4153902.html