SQL 中while循环语句

最新推荐文章于 2025-06-18 18:05:39 发布

jimmy_zjw

最新推荐文章于 2025-06-18 18:05:39 发布

阅读量3.7k

点赞数

CC 4.0 BY-SA版权

文章标签： sql exception insert

本文链接：https://blog.youkuaiyun.com/jimmy_zjw/article/details/1838752

本文提供了使用SQL进行while循环的示例代码，演示了如何在循环中更新表数据。通过具体的PL/SQL块展示了复杂的子查询操作，并在每次循环迭代中更新HSM_HSE_STCK_VRBL_ATTR表。

摘要生成于 C知道，由 DeepSeek-R1 满血版支持，前往体验 >

SQL 语句while循环模版:

declare
i number(10) :=0;

begin
while i<1000 loop
insert into stu_liyy1 values(i,'lyy');
i :=i+1;
end loop;
commit;

exception
when others then
rollback;

end;

例子:

declare a int:=1;
begin
while a<=30 loop
update HSM_HSE_STCK_VRBL_ATTR v set v.HSE_STCK_RSRV_CODE=
(select reserved_code from (
select rownum i,stock_key, reserved_code from (
select w.MAIN_STCK_KEY stock_key,w.TNCY_ACQ_WAY_CODE reserved_code
from WRK_TNCY w where w.TNCY_STS_CODE = 'W'
union
select a.STCK_KEY stock_key,w.TNCY_ACQ_WAY_CODE reserved_code
from WRK_TNCY w,WRK_TNCY_ADTN_UNIT a
where w.TNCY_KEY=a.TNCY_KEY
and w.TNCY_STS_CODE = 'W'
))where i = a) where v.HSE_STCK_KEY =
(select stock_key from (
select rownum i,stock_key, reserved_code from (
select w.MAIN_STCK_KEY stock_key,w.TNCY_ACQ_WAY_CODE reserved_code
from WRK_TNCY w where w.TNCY_STS_CODE = 'W'
union
select a.STCK_KEY stock_key,w.TNCY_ACQ_WAY_CODE reserved_code
from WRK_TNCY w,WRK_TNCY_ADTN_UNIT a
where w.TNCY_KEY=a.TNCY_KEY
and w.TNCY_STS_CODE = 'W'
))where i = a);
a:=a+1;
end loop;
end;