Question

oracle存储过程改错，一句话。

SELECT vcount INTO count(ZBB_BH) FROM ZBB WHERE
(ZBB_DATA not between ZBB_BOTTOM and ZBB_TOP)
and ZBB_BH = '7390807820' group by ZBB_BH

提示出这里不能用分组函数，哪里错了？

Answer 1

SELECT vcount INTO count(ZBB_BH) FROM ZBB WHERE
(ZBB_DATA not between ZBB_BOTTOM and ZBB_TOP)
and ZBB_BH = '7390807820' group by ZBB_BH

select ......into 表名 --这个表名是你要写入查询数据的表名，数据库中原先不存在。如果原先存在这个表则需要用insert语句
from ........where...

Answer 2

我的天啊，into到字段，你这怎么into到 count ，，，这是什么意思，我没懂，，，，
vcount 是变量么？
我怎么觉得是这样的呢。。。
SELECT count(ZBB_BH) INTO vcount FROM ZBB WHERE
(ZBB_DATA not between ZBB_BOTTOM and ZBB_TOP)
and ZBB_BH = '7390807820' group by ZBB_BH

Answer 3

select count(ZBB_BH) into vcount ....

Answer 4

SELECT count(ZBB_BH) INTO vcount FROM ZBB WHERE
(ZBB_DATA not between ZBB_BOTTOM and ZBB_TOP)
and ZBB_BH = '7390807820' group by ZBB_BH