can you do a for loop in sql code example
Example 1: sql for loop
DECLARE
n NUMBER(2);
BEGIN
FOR n IN 10 .. 15 LOOP
dbms_output.put_line('n= ' || n);
END LOOP;
END;
n= 10
n= 11
n= 12
n= 13
n= 14
n= 15
Example 2: sql for loop
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