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