ORACLE 存储过程 在此 SELECT 语句中缺少 INTO 子句,怎么办?
select出来的结果要放到变量中去,select ... into .... from ... where ....
oracle循环执行sql语句报错:在此 SELECT 语句中缺少 INTO 子句
declare
i int:=1;
begin
loop
execute immediate 'select SEQ_WCM_RESOURCE.nextval from dual CONNECT BY LEVEL<130000';
exit when i=10;
i:=i+1;
end loop;
end;