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

14 votes352 views3 answers
Trim sql
SQL
1 vote391 views1 answer
Sql select sum group by id laravel
SQL
1 vote573 views1 answer
Postgres convert text to number
SQL
0 vote312 views1 answer
Insert or update cassandra
SQL
8 votes341 views1 answer
Oracle create datafile
SQL
0 vote356 views1 answer
Mysql db dump restore max file size issue
SQL
0 vote330 views1 answer
Mysql import datetime YYYY-MM-DDThh:mm:ss.000000Z
SQL
0 vote414 views1 answer
HOW to select specific table data from an mysql databse server:
SQL
1 vote329 views2 answers
Sqlalchemy postgres timestamp with timezone
SQL
0 vote329 views1 answer
Postgresql heritage
SQL