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 vote165 views1 answer
Sql change date format
SQL
1 vote171 views3 answers
Psql: error: FATAL: role "postgres" does not exist
SQL
0 vote184 views1 answer
How to access to mysql without root
SQL
20 votes185 views4 answers
Sql count if
SQL
6 votes217 views3 answers
Rename column ORACLE
SQL
0 vote179 views1 answer
How to get first 10 records of a table in mysql
SQL
0 vote186 views2 answers
SQLSTATE[HY000]: General error: 3780 Referencing column 'role_id' and referenced column 'id' in foreign key constraint 'user_role_id foreign' are incompatible.
SQL
1 vote187 views1 answer
Sql set auto increment back to 0
SQL
3 votes159 views4 answers
Order by desc postgres
SQL
0 vote189 views1 answer
Drop index in sql
SQL