sorry !select t1.shipper_cod, prebill, fact, pay, change, t2.shipper_cod, original, prepay
from (select shipper_cod, sum(prebill_mny) prebill, sum(fact_mny) fact, sum(pay_mny) pay, sum(change_mny) change
from m_cw_arre_detail
where count_dte = :ld_dte
group by shipper_cod) t1 full join
(select shipper_cod, nvl(sum(decode(original_id, '0', prepay_mny, 0)), 0) prepay,
nvl(sum(decode(original_id, '1', prepay_mny, 0)), 0) original
from shipper_prepay
where prepay_dte <= :ld_dte
and pay_id = '0'
group by shipper_cod ) t2 on t1.shipper_cod = t2.shipper_cod
from (select shipper_cod, sum(prebill_mny) prebill, sum(fact_mny) fact, sum(pay_mny) pay, sum(change_mny) change
from m_cw_arre_detail
where count_dte = :ld_dte
group by shipper_cod) t1 full join
(select shipper_cod, nvl(sum(decode(original_id, '0', prepay_mny, 0)), 0) prepay,
nvl(sum(decode(original_id, '1', prepay_mny, 0)), 0) original
from shipper_prepay
where prepay_dte <= :ld_dte
and pay_id = '0'
group by shipper_cod ) t2 on t1.shipper_cod = t2.shipper_cod
解决方案 »
- 为什么运行exec无法执行存储过程,提示无效sql语句
- oracle view 增加列,求高手解答!
- JDBC Statement 批量更新数据的性能问题
- oracle 中 SQL PLUS环境中使用某个数据库用什么命令啊
- 双机热备的服务器在磁盘阵列柜中装ORACLE,切换服务器主机时Oracle数据库无法打开
- 再问job问题,在线等!!
- 求电子书!!!!!!重谢!!!!!感激!!!《oracle 9i for window 数据库系统培训教程 》,有基础篇与高级篇两本,作者黄河。
- 请教!如何更新字段值?在线等。。
- 怎么开始学习oracle
- 帮我走到ORACLE的门前?
- 请教proc中报“ora [1002]”错误原因
- oracle和asp问题!!!!!高分!!!
语法是没有问题得。
oracle是有bug的