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 vote216 views1 answer
Timestamp(0) postgresql
SQL
0 vote219 views1 answer
Extract sql from query object sqlalchemy
SQL
0 vote228 views1 answer
Sql Top 5 sutradara dengan filem terbanyak
SQL
7 votes201 views2 answers
Show size database mysql
SQL
0 vote206 views1 answer
Sql server alter table add column datetime default current_timestamp
SQL
8 votes256 views1 answer
Mac restore mysql database command line
SQL
0 vote193 views1 answer
Oracle activate program
SQL
0 vote216 views1 answer
Mysql root localhost run
SQL
0 vote236 views1 answer
Stop psql server windows
SQL
0 vote220 views1 answer
Setval postgres example table id
SQL