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 vote112 views1 answer
Oracle last connection
SQL
0 vote130 views1 answer
Import sql in postgresql
SQL
0 vote108 views1 answer
Hive batch drop table
SQL
1 vote118 views1 answer
Copy postgres table from one schema into another
SQL
3 votes118 views3 answers
Sql last week
SQL
3 votes117 views2 answers
Sqlite print all column names
SQL
7 votes121 views3 answers
Postgresql dump and restore db
SQL
0 vote71 views0 answer
SQL
0 vote117 views1 answer
How to select a row in sql
SQL
18 votes110 views3 answers
Mysql number format
SQL