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 vote288 views1 answer
Pass array parameter to stored procedure c#
SQL
0 vote302 views1 answer
Sqlite löschen einer tabelle
SQL
0 vote236 views1 answer
Ms sql print more than 1 variable
SQL
31 votes286 views4 answers
How to get duplicate records with multiple field in sql
SQL
1 vote293 views1 answer
Sometimes i cant edit sql developer
SQL
1 vote289 views1 answer
Sql padd let with zeros
SQL
0 vote268 views1 answer
Oracle right characters
SQL
2 votes287 views1 answer
Sql get the name of user pc
SQL
17 votes305 views4 answers
Postgres list users
SQL
0 vote294 views1 answer
Sql comand for removing data from table
SQL