Sql for loop

This article is tagged with: Sql for loop and mysql

sql for loop

DECLARE
n NUMBER(2);
BEGIN
FOR n IN 10 .. 15 LOOP
dbms_output.put_line('n= ' || n);
END LOOP;
END;
# When executed the output should be...
n= 10
n= 11
n= 12
n= 13
n= 14
n= 15

sql for loop

/*
For loop in sql
*/
Example:
DECLARE
a number(2);
BEGIN
FOR a in 10 .. 20 LOOP
dbms_output.put_line('value of a: ' || a);
END LOOP;
END;
/
Output:
value of a: 10
value of a: 11
value of a: 12
value of a: 13
value of a: 14
value of a: 15
value of a: 16
value of a: 17
value of a: 18
value of a: 19
value of a: 20

This article is tagged with: Sql for loop and mysql