oracle中为何语句一直执行？？？请求帮助啊！！！

Question

各位大侠，我在oracle中执行一个语句，可是不知道为什么 一直显示 executing 而不出查询结果呢？？这个问题，困扰了我很久，请求大家能够指教，谢谢了！！！
代码粘贴如下：
select * from (select t.*,rownum rn from (
                                       select a.id,a.jh,a.cb,a.csfs,a.tssglx,a.SKCB,b.zj skjs,a.ZYCB,c.zyjs,a.qtcb,a.lrrq,b.sgrq,c.zlhsd,trim(c.yggg) yggg,
                                             c.fy from v_yszcb_dl a 
                                            left join v_js_xjsk b on(b.id=a.id) left join
                                            (select distinct c.je zyjs,c.zlhsd,c.id,
                                                trim(c.yggg) yggg,c.fy from  v_js_xjzy c)
                                            c on(a.id=c.ID) where jh in ('杏3-3-丙523','杏4-31-625')) t order by id desc)

Answer 1

select * 
from (select t.*,rownum rn 
      from (select a.id,a.jh,a.cb,a.csfs,a.tssglx,a.SKCB,b.zj                  
            skjs,a.ZYCB,c.zyjs,a.qtcb,a.lrrq,b.sgrq,c.zlhsd,c.yggg,c.fy 
            from v_yszcb_dl a  
            left join v_js_xjsk b on(b.id=a.id) 
            left join (select distinct c.je zyjs,c.zlhsd,c.id,
                       trim(c.yggg) yggg,c.fy from v_js_xjzy c
                      ) c  on(a.id=c.ID) 
            where jh in ('杏3-3-丙523','杏4-31-625')
            ) t 
      order by id desc)数据大概多少?