直接试试下面的,看多长时间?cursor cur_qf is
SELECT a.Yhbh,
a.Yhmc,
a.Qch,
Decode(Nvl(a.Ydlb, '5'), '8', '5', Nvl(a.Ydlb, '5')) Ydlb,
SUM(b.Qfje) Qfje
FROM Tb_Yd_Yhydxxtz a, Tb_Sf_Yhqftz b
WHERE a.Yhbh = b.Yhbh
AND a.Qch LIKE '0201' || '%'
AND b.Fxny <= To_Date('20050301', 'YYYYMMDD')
AND Decode(Nvl(a.Ydlb, '5'), '8', '5', Nvl(a.Ydlb, '5')) = '2'
AND b.Qfje > 0
AND b.Qfbz <> '3'
GROUP BY a.Yhbh,
a.Yhmc,
a.Qch,
Decode(Nvl(a.Ydlb, '5'), '8', '5', Nvl(a.Ydlb, '5'))
ORDER BY Qfje DESC;
SELECT a.Yhbh,
a.Yhmc,
a.Qch,
Decode(Nvl(a.Ydlb, '5'), '8', '5', Nvl(a.Ydlb, '5')) Ydlb,
SUM(b.Qfje) Qfje
FROM Tb_Yd_Yhydxxtz a, Tb_Sf_Yhqftz b
WHERE a.Yhbh = b.Yhbh
AND a.Qch LIKE '0201' || '%'
AND b.Fxny <= To_Date('20050301', 'YYYYMMDD')
AND Decode(Nvl(a.Ydlb, '5'), '8', '5', Nvl(a.Ydlb, '5')) = '2'
AND b.Qfje > 0
AND b.Qfbz <> '3'
GROUP BY a.Yhbh,
a.Yhmc,
a.Qch,
Decode(Nvl(a.Ydlb, '5'), '8', '5', Nvl(a.Ydlb, '5'))
ORDER BY Qfje DESC;
解决方案 »
- oracle10 中A服务器的归档日志,如何放在一份在服务器B中?
- 新手求助
- [提问]怎样从Alert.log文件中详细了解Oracle 9i启动过程
- window 2000 server下如何设置Oracle8i全文检索啊?
- 删除表中的重复数据
- (请教)启动oracle9i实例报错!
- 各位高手帮忙看看这样的SQL语句怎么样在ORACLE中实现
- 我以a用户建立的表b,sqlplus查询为什么非要加引号?
- oracl问题,大神求解决!
- 新手求教WIN8.1装oracle 11g 碰到问题
- 菜鸟提问:需要那些软件?
- 如何在存储过程中使用dbms_output.put_line输出出错的sql语句!!
郁闷。