读书人

select into v1, into v2,该如何解决

发布时间: 2012-09-14 23:00:49 作者: rapoo

select into v1, into v2
select a, count(1) into v1, sum(b) into v2
from test
group by a;

oracle中这样写认为语句非法,像这种多个into的该则么写?

[解决办法]
1个into


select count(1),sum(b) into v1,v2 from ...
[解决办法]
into前放所有需要的字段,into后方接收的变量。
select c1,c2,... into v1,v2,... from table

读书人网 >oracle

热点推荐