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 vote246 views1 answer
Mysql case when null
SQL
0 vote225 views1 answer
Add plugins to mysql workbench
SQL
0 vote249 views2 answers
How to add CHECK constraint to a column in postgres
SQL
0 vote234 views1 answer
Oracle sql generate list of days
SQL
1 vote235 views2 answers
Postgresql get difference in hours between two dates
SQL
0 vote216 views2 answers
Sql select inside select
SQL
0 vote228 views1 answer
Soql last week
SQL
1 vote239 views1 answer
How to remove identity from a column in sql server
SQL
1 vote187 views1 answer
Postgres kill pid
SQL
1 vote243 views1 answer
T-sql find object by name
SQL