- 论坛徽章:
- 0
|
order by
气死我了,刚才回复不成功出现 invalid_session
而又不能回到前一个页面,白写了。
我看了你的SQL发现里边有两处错误,所以执行不了,而不是没有执行。
execute immediate
'INSERT INTO STUINFO.XG_YX_BJTZ
SELECT BM,COUNT(*) AS TOTAL,SUM(2-XBDM) AS NSRS,SUM(XBDM-1) AS VSRS
FROM STUINFO.XJ_XJB
WHERE ZYXH=VZYXH -- 这里VZYXH是PL/SQL变量,开始没注意到,以为是表字段了,不能写在里边
GROUP BY ROLLUP(BM); -- 这里分号多余
ORDER BY BM';
修改成:
execute immediate
'INSERT INTO STUINFO.XG_YX_BJTZ
SELECT BM,COUNT(*) AS TOTAL,SUM(2-XBDM) AS NSRS,SUM(XBDM-1) AS VSRS
FROM STUINFO.XJ_XJB
WHERE ZYXH=:VZYXH
GROUP BY ROLLUP(BM)
ORDER BY BM'
using VZYXH;
不过我想问你为什么需要Order by, 有group by 那么结果就已经是排序后的 |
|