例:
(select '1' as k ,'a' as kk from dual)
union all
(select '2' as k ,'b' as kk from dual)
order by k和
select '1' as k ,'a' as kk from dual
union all
select '2' as k ,'b' as kk from dual
order by k运行结果取出来的没区别
但是用第一个SQL取得数据,hasrows就是false
第二个SQL取得的数据,hasrows就是true为什么啊?
(select '1' as k ,'a' as kk from dual)
union all
(select '2' as k ,'b' as kk from dual)
order by k和
select '1' as k ,'a' as kk from dual
union all
select '2' as k ,'b' as kk from dual
order by k运行结果取出来的没区别
但是用第一个SQL取得数据,hasrows就是false
第二个SQL取得的数据,hasrows就是true为什么啊?
解决方案 »
免费领取超大流量手机卡,每月29元包185G流量+100分钟通话, 中国电信官方发货