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

3 votes125 views3 answers
Restart mysql mac
SQL
5 votes109 views1 answer
Oracle find foreign key dependencies
SQL
0 vote113 views1 answer
Https://livesql.oracle.com/apex/livesql/s/l8fedwph53gt5gigbacwvu6m0
SQL
1 vote127 views1 answer
T-SQL / AZURE Reseed
SQL
0 vote113 views1 answer
Top 3 salary in sql
SQL
0 vote106 views1 answer
Insert into using contant values and source table columns with sql
SQL
15 votes115 views5 answers
Show tables in oracle
SQL
0 vote148 views1 answer
Jpa generationtype sequence mysql
SQL
0 vote61 views1 answer
Update row in sqlite python
SQL
0 vote132 views1 answer
Oracle job session
SQL