select r1.city_code,r1.city_name,r2.* from
(SELECT sum(decode(b.sale_code,00002607,1,0)*decode(c.brand_code,10002,1,0)*decode(c.style_code,10043,1,0)) a00002607_10002_10043 , sum(decode(b.sale_code,00003921,1,0)*decode(c.brand_code,10002,1,0)*decode(c.style_code,10043,1,0)) a00003921_10002_10043 , sum(decode(b.sale_code,00003931,1,0)*decode(c.brand_code,10002,1,0)*decode(c.style_code,10043,1,0)) a00003931_10002_10043 , sum(decode(b.sale_code,00004207,1,0)*decode(c.brand_code,10002,1,0)*decode(c.style_code,10043,1,0)) a00004207_10002_10043 , sum(decode(b.sale_code,00004210,1,0)*decode(c.brand_code,10002,1,0)*decode(c.style_code,10043,1,0)) a00004210_10002_10043 , sum(decode(b.sale_code,00004214,1,0)*decode(c.brand_code,10002,1,0)*decode(c.style_code,10043,1,0)) a00004214_10002_10043 , sum(decode(b.sale_code,00004216,1,0)*decode(c.brand_code,10002,1,0)*decode(c.style_code,10043,1,0)) a00004216_10002_10043 , sum(decode(b.sale_code,00004219,1,0)*decode(c.brand_code,10002,1,0)*decode(c.style_code,10043,1,0)) a00004219_10002_10043 from tb_mobile_stock c,sphonesalcfg b,tb_sal_imei a where a.imei=c.imei and b.sale_code = a.sale_code group by c.region_code) r2,(select c.region_code city_code,count(*) sumall from tb_mobile_stock c,sphonesalcfg b,tb_sal_imei a where a.imei=c.imei and b.sale_code = a.sale_code group by c.region_code)r3 where r1.city_code=r2.city_code(+) and r1.city_code=r3.city_code(+) and r2.city_code=r3.city_code
由于我有很多的sum语句,所以出现了这个错误,有什么好的方法可以解决吗?
(SELECT sum(decode(b.sale_code,00002607,1,0)*decode(c.brand_code,10002,1,0)*decode(c.style_code,10043,1,0)) a00002607_10002_10043 , sum(decode(b.sale_code,00003921,1,0)*decode(c.brand_code,10002,1,0)*decode(c.style_code,10043,1,0)) a00003921_10002_10043 , sum(decode(b.sale_code,00003931,1,0)*decode(c.brand_code,10002,1,0)*decode(c.style_code,10043,1,0)) a00003931_10002_10043 , sum(decode(b.sale_code,00004207,1,0)*decode(c.brand_code,10002,1,0)*decode(c.style_code,10043,1,0)) a00004207_10002_10043 , sum(decode(b.sale_code,00004210,1,0)*decode(c.brand_code,10002,1,0)*decode(c.style_code,10043,1,0)) a00004210_10002_10043 , sum(decode(b.sale_code,00004214,1,0)*decode(c.brand_code,10002,1,0)*decode(c.style_code,10043,1,0)) a00004214_10002_10043 , sum(decode(b.sale_code,00004216,1,0)*decode(c.brand_code,10002,1,0)*decode(c.style_code,10043,1,0)) a00004216_10002_10043 , sum(decode(b.sale_code,00004219,1,0)*decode(c.brand_code,10002,1,0)*decode(c.style_code,10043,1,0)) a00004219_10002_10043 from tb_mobile_stock c,sphonesalcfg b,tb_sal_imei a where a.imei=c.imei and b.sale_code = a.sale_code group by c.region_code) r2,(select c.region_code city_code,count(*) sumall from tb_mobile_stock c,sphonesalcfg b,tb_sal_imei a where a.imei=c.imei and b.sale_code = a.sale_code group by c.region_code)r3 where r1.city_code=r2.city_code(+) and r1.city_code=r3.city_code(+) and r2.city_code=r3.city_code
由于我有很多的sum语句,所以出现了这个错误,有什么好的方法可以解决吗?
解决方案 »
- ORACLE用户的ora_j00*进程占CPU高的疑问
- select file_name from dba_data_files where tablespace_name='user01'为什么执行结果是未选定行?
- 紧急求救!关于linux下的/dev/oralv
- 求助:在Oracle数据库中按拼音首字母查询,请高手指点
- 能否在oracle的存储过程中使用嵌套游标?
- 请问Oracle里面的NET EASY CONFIG怎么安装不上去?
- net8无法安装,
- 请问怎样查看自己的历史帖子
- 请问ORACLE中如何把A表一些记录增加到B表中?
- union性能
- 按每日统计,没有这一日的也要显示,为0
- .dmp无法导入Oracle10g
( select sum(a1),sum(a2),... from a,b,c where a.id=c.id and b.code=a.code group by c.code) b,
(select c.code,count(*) sumall from a,b,c where a.id=c.id and b.code=a.code group by c.code) c
where a.code=b.code(+) and a.code=b.code(+) and b.code=c.code(+)这样的语句要是不出错才怪。建议,搂主,一步一步来,必要搞这种可读性差到连自己都搞不懂的语句。。呵呵。。