PL/SQL个人学习笔记(二)
时间:2022-03-13 23:17
IF条件
declare
cursor s isselect version from city_server t;
s_ city_server.version%type;
begin
open s;
fetch s into s_;
if s_>2
then
DBMS_OUTPUT.put_line(s_);
end if;
close s;
end;
LOOP循环
declare
cursor s is
select version from city_server t;
s_ city_server.version%type;
begin
open s;
loop
fetch s into s_;
exit when s%notfound;
DBMS_OUTPUT.put_line(s_);
end loop;
close s;
end;