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 vote232 views1 answer
Mysql get date diff in months
SQL
11 votes230 views1 answer
Sql query to find duplicates in column
SQL
1 vote216 views2 answers
Mysql spring boot application.properties
SQL
0 vote244 views1 answer
Kill slow queries mysql
SQL
0 vote260 views1 answer
Declare or use variable in snowflake
SQL
0 vote238 views1 answer
Find duplicate users by email address in mysql
SQL
0 vote226 views1 answer
Sql contains vs like
SQL
5 votes241 views1 answer
How to get all dates in a month in oracle
SQL
0 vote254 views1 answer
Sql column contains special character
SQL
0 vote221 views1 answer
Android studio SQLiteDatabase delete all data in database
SQL