sábado, 30 de noviembre de 2013

basicos loops

/************* 019 LOOP2 ***********/

SET SERVEROUTPUT ON

BEGIN
  LOOP
    DBMS_OUTPUT.PUT_LINE('I WANTED YOU');
  END LOOP;
END;

DECLARE
  l_count PLS_INTEGER := 0;

BEGIN 
  LOOP
    DBMS_OUTPUT.PUT_LINE('MUCH BETTER');
    l_count := l_count + 1;
    EXIT WHEN l_count = 20;
  END LOOP;

END;


/************* 020 LOOP2 ***********/

SET SERVEROUTPUT ON

BEGIN
  FOR v_count IN 1 .. 20 LOOP
    DBMS_OUTPUT.PUT_LINE('Iteration: ' || v_count);
  END LOOP;

END;


/************* 021 LOOP2 ***********/

SET SERVEROUTPUT ON

DECLARE
  l_count PLS_INTEGER := 1;

BEGIN
  WHILE l_count <= 20 LOOP
    DBMS_OUTPUT.PUT_LINE('While loop iteration: ' || l_count);
    l_count := l_count + 1;
  END LOOP;
END;

No hay comentarios:

Publicar un comentario