¶Ôpl/sql Óï¾äµÄÓÅ»¯£¨Éϼ¯£©

¶ÔÕâ¸ö½øÐÐÓÅ»¯
select n5001 Ãŵê,n5002 ²¿ÃÅ,n5004 С·ÖÀà,n5019 ÉÌÆ·±àÂë,c01d21 ÉÌÆ·Ãû³Æ,
nvl(xse,0)-nvl(dzxs,0) ÏúÊÛ,
mle ëÀû,
nvl(xl,0)-nvl(dzsl,0) ÏúÁ¿
 from
(select n5001,n5002,n5004,n5019,sum(n5011) xse,sum(n5016) mle,sum(n5023) xl
from n50
where to_char(n5010,'yyyymmdd')>='20100401'
and to_char(n5010,'yyyymmdd')<='20100431'
group by n5001,n5002,n5004,n5019),
(select g08,g09,g02,sum(g03*g07) dzxs,sum(G03) dzsl from batchgoods
where to_char(g04,'yyyymmdd')>='20100401'
and to_char(g04,'yyyymmdd')<='20100431'
group by g08,g09,g02),c01d
where n5001=g08(+)
and n5019=g02(+)
and n5001=c01d00(+)
and n5019=c01d01(+)
Ö´Ðмƻ®
SELECT STATEMENT, GOAL = CHOOSE            Cost=10060    Cardinality=3931    Bytes=475651
 MERGE JOIN OUTER            Cost=10060    Cardinality=3931    Bytes=475651
  SORT JOIN            Cost=8063    Cardinality=3931    Bytes=338066
   NESTED LOOPS OUTER            Cost=7952    Cardinality=3931    Bytes=338066
    VIEW    Object owner=FZDC        Cost=4015    Cardinality=3931    Bytes=239791
     SORT GROUP BY            Cost=4015    Cardinality=3931    Bytes=149378
      TABLE ACCESS FULL    Object owner=FZDC    Object name=N50    Cost=3955    Cardinality=3931    Bytes=149378
    TABLE ACCESS BY INDEX ROWID    Object owner=FZDC    Object name=C01D