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 vote154 views1 answer
Get all employees if name ends with in sql
SQL
0 vote165 views1 answer
Mysql autoincrement valor inicial
SQL
10 votes166 views3 answers
Sql limit results
SQL
1 vote168 views1 answer
Postgresql last element of array
SQL
0 vote184 views1 answer
Helptext in sql
SQL
1 vote169 views1 answer
How to between in sql
SQL
0 vote175 views1 answer
Mysql 8 geo to json
SQL
0 vote172 views1 answer
Mysql user set plugin
SQL
4 votes172 views1 answer
Mysql copy table with new name
SQL
4 votes159 views3 answers
Create database in mySQL
SQL