Laboratorio#1- Sentencias

· loop

SET SERVEROUTPUT ON;

SET VERIFY OFF;

declare

v number:= 2;

begin

loop

dbms_output.put_line(v);

v:=v+2;

exit when v >10;

end loop;

end;

· while

SET SERVEROUTPUT ON;

SET VERIFY OFF;

declare

j number:= 2;

begin

while j<=10 loop

dbms_output.put_line(j);

j:=j*2;

end loop;

end;

· for

SET SERVEROUTPUT ON;

SET VERIFY OFF;

declare

c number;

d number;

begin

for c in 1..10 loop

dbms_output.put_line('ASC '||c);

end loop;

begin

for d in REVERSE 1..10 loop

dbms_output.put_line('DESC '||d);

end loop;

end;

end;

· if

SET SERVEROUTPUT ON;

SET VERIFY OFF;

declare

v_num number:= &v;

begin

if v_num<50>

dbms_output.put_line('valor pequnio');

ELSIF v_num<100>

dbms_output.put_line('valor mediano');

else

dbms_output.put_line('valor grande');

end if;

end;