Oracle for loop

DECLARE
    i NUMBER;
BEGIN
    FOR i IN 1..5
        LOOP
            dbms_output.PUT_LINE('i value : ' || i);
        END LOOP;
END;

For loop in oracle

DECLARE
    count number(2) := 10;
BEGIN
    FOR count in 10..20                         (FOR count in REVERSE 10..20)
    LOOP
        dbms_output.put_line("COUNT : " || count);
    END LOOP;
END;

-- FOR count in 10..20 
-- it will print value from 10 to 20
-- FOR count in REVERSE 10..20 
-- it will print value from 20 to 10

Similar codes

0 vote221 views1 answer
Create table sql generator
SQL
6 votes221 views2 answers
Sql sequence
SQL
1 vote215 views1 answer
Select count distinct multiple columns sql server
SQL
2 votes204 views1 answer
Oracle table size
SQL
2 votes222 views1 answer
Guid to string sql
SQL
0 vote229 views2 answers
Dumping sql table
SQL
0 vote212 views1 answer
R2dbc-postgresqldriver dependency
SQL
1 vote181 views1 answer
Python escape string for sql
SQL
0 vote276 views1 answer
Oracle convert int to date
SQL
5 votes209 views2 answers
Mysql date greater than 30 days
SQL