--while loop 循环
declare
ii int;
begin
ii:=10;
while(ii<20) loop
ii:=ii+1;
dbms_output.put_line(ii);
end loop;
end;
--普通loop 循环
declare
ii number(4);
begin
ii:=1;
loop
dbms_output.put_line(ii);
exit when ii>5; -- 推出循环
ii:=ii+1;
end loop;
end;
-- for loop 循环
declare
begin
for ii in 1..10 loop
dbms_output.put_line(ii);
end loop;
end;
-- if判断
declare
cut number(2);
eno number(6);
begin
eno := &empno;
select count(*) into cut from emp where empno=eno; --按条件查询,是否成功
if cut=1 then --判断
dbms_output.put_line('成功');
else
dbms_output.put_line('失败');
end if;
end;
PL SQL简单
最新推荐文章于 2023-06-08 17:20:25 发布