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 vote202 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
-1 vote228 views1 answer
Sql vs nosql or mysql vs mongodb
SQL
0 vote233 views1 answer
Sql query tags
SQL
-1 vote184 views1 answer
Search all tables all columns for a specific value in mssql-server
SQL
8 votes184 views3 answers
Postgresql connection string c#
SQL
0 vote196 views1 answer
Exception message: The connection name 'SqlServices' was not found in the applications configuration or the connection string is empty.
SQL
0 vote191 views1 answer
Get all employees if name ends with in sql
SQL
3 votes333 views2 answers
Oracle sql first day of month
SQL
1 vote203 views2 answers
Mysql switch case
SQL
0 vote191 views1 answer
Add created and updatedAt fields in mysql
SQL