我的SQL语句是:
select * from userinfo where (userno is null or userno = '' or atf_userno = userno ) and
(username is null or username = '' or atf_username = username ) and
(mobile is null or mobile = '' or atf_mobile = mobile ) and
to_number(substr(atf_subtime,0,8 )) >= to_number(starttime) and
to_number(substr(atf_subtime,0,8 )) <= to_number(endtime);