select *
from myTable
where 1=1
and 1=(
case when nvl(p_a,'') = '' and c_a = p_a then 1
when nvl(p_b,'') = '' and c_b = p_b then 1
when nvl(p_c,'') = '' and c_c = p_c then 1
end );
from myTable
where 1=1
and 1=(
case when nvl(p_a,'') = '' and c_a = p_a then 1
when nvl(p_b,'') = '' and c_b = p_b then 1
when nvl(p_c,'') = '' and c_c = p_c then 1
end );
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货