判断字段是否为空在拼接sql字句好了。
........
if(:xx is null and :yy is not null) then
..........
elsif (:xx is not null and :yy is not null) then
............
end if
........
if(:xx is null and :yy is not null) then
..........
elsif (:xx is not null and :yy is not null) then
............
end if
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货