日期:2014-05-17  浏览次数:21035 次

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