|
问大家一个SQL的问题:
select a.* from
(
select o.BILLCYCL obill,t.BILLCYCL tbill,o.SP_ID ospid,t.SP_ID tspid,o.AREA_ID oarea,t.AREA_ID tarea,
o.SP_CODE ospcode,t.SP_CODE tspcode,o.SETT_TYPE osett,t.SETT_TYPE tsett,o.CNT ocnt,t.CNT tcnt
from SP_MO_SVC@spjs o full outer join SP_MT_SVC@spjs t on o.BILLCYCL=t.BILLCYCL and o.SP_ID=t.SP_ID and o.AREA_ID=t.AREA_ID and
o.SP_CODE=t.SP_CODE and o.SETT_TYPE=t.SETT_TYPE and o.SVC_ID=t.SVC_ID
) a
where a.obill = '200812' or a.tbill='200812';
我这个SQL在plsql里显示到5400条时就停在那不动,在sqlplus里运行到5460里就停在那不动,过了很长时间才把后面的数据显示出来,总共也就5471条,这可能是什么原因啊? |
|