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

1 vote185 views1 answer
Mysql print variable
SQL
-1 vote105 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL
25 votes239 views6 answers
Change column name mysql
SQL
1 vote165 views1 answer
Mysql how to truncate table with foreign keys
SQL
1 vote152 views2 answers
Difference between in and between in sql
SQL
0 vote180 views1 answer
Select * where id = 1,2,3
SQL
5 votes139 views1 answer
Mysql change primary key
SQL
1 vote136 views1 answer
Using SQL in rails migration
SQL
1 vote105 views1 answer
Ms sql how to see active job current run time
SQL
2 votes154 views1 answer
Oracle convert run_duration to number
SQL