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 vote277 views1 answer
Split string by comma in sql server
SQL
0 vote271 views1 answer
Group by sql not ordering issues
SQL
36 votes283 views6 answers
Rename table sql
SQL
11 votes334 views2 answers
Import mysql dump command line windows
SQL
1 vote270 views1 answer
Postgres get month name from date
SQL
27 votes282 views3 answers
Mysql show tables in database
SQL
0 vote269 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
0 vote284 views2 answers
Drop tables from local table database postgres
SQL
0 vote301 views2 answers
Wordpress change url after migration mysql query
SQL
0 vote252 views1 answer
How to see the query of a view in mysql
SQL