PL/SQL个人学习笔记（二）

IF条件
declare
cursor s is
select 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;