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

13 votes356 views3 answers
Insert mysql ifile nto database
SQL
10 votes345 views3 answers
Join multiple tables sql
SQL
0 vote325 views1 answer
Mysql grant user wildcard database
SQL
0 vote360 views1 answer
Select true if exists on another table or false sqlserver
SQL
1 vote360 views1 answer
Sqlalchemy order by descending
SQL
2 votes340 views1 answer
Removing view
SQL
0 vote321 views1 answer
Add SuperUser MySQL
SQL
10 votes344 views2 answers
Rtrim sql
SQL
0 vote364 views1 answer
Sql query wordpress export post
SQL
14 votes312 views2 answers
How to auto increment in sql
SQL