Question

oracle循环执行sql语句报错：在此 SELECT 语句中缺少 INTO 子句

我想要重复执行下面这句sql 10遍

select SEQ_WCM_RESOURCE.nextval from dual CONNECT BY LEVEL<130000;

我写的sql如下

declare
i int:=1;
begin
loop
select SEQ_WCM_RESOURCE.nextval from dual CONNECT BY LEVEL<130000;
exit when i=10;
i:=i+1;
end loop;
end;

报了 在此 SELECT 语句中缺少 INTO 子句
请问要怎么修改，才能实现

Answer 1

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;