CODE EXAMPLE FOR SQL

iterative instruction sql

DECLARE  
  i NUMBER(4) := 10;  
BEGIN  
  WHILE (i <= 100)
  LOOP    
    DBMS_OUTPUT.PUT_LINE(i);   
    i := i+10;
  END LOOP;  
END;