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

25 votes115 views4 answers
Import mysql dump command line
SQL
0 vote103 views2 answers
Script all indexes in a database
SQL
0 vote96 views1 answer
Ms Sql set us timezone
SQL
3 votes102 views4 answers
Show sql server database
SQL
1 vote135 views1 answer
Epoch time converter in snowflake
SQL
6 votes105 views2 answers
Mysql check auto increment value
SQL
1 vote103 views1 answer
Set permanent SET GLOBAL sql_mode ubuntu
SQL
1 vote102 views1 answer
How to find median of a column sql
SQL
4 votes103 views1 answer
Delete record mysql query
SQL
0 vote122 views3 answers
Classement rang mysql 7
SQL