Oracle1

declare
msg varchar2(100);
num integer :=1;
begin
 
msg :='a';
case msg
  when 'a' then
dbms_output.put_line('1');

else
  dbms_output.put_line('3');
end case ;

<<bloop>>

loop
 
num:=num+1;
  dbms_output.put_line(num);
if num>10 then
 
exit bloop;

end if ;

end loop;

for inx in 1..20 loop
 
num:=num+1;
  dbms_output.put_line(num);
end loop;

end;

posted @ 2017-05-16 11:27  甜菜波波  阅读(132)  评论(0编辑  收藏  举报