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 vote156 views1 answer
To_date sql
SQL
0 vote168 views1 answer
Select top values sql
SQL
0 vote165 views1 answer
Postgres get running query
SQL
0 vote139 views1 answer
Oracle list proxy users
SQL
0 vote151 views1 answer
Dialect undefined does not support db:create / db:drop commands
SQL
1 vote97 views1 answer
Alter user mysql native password
SQL
2 votes136 views1 answer
Sql create database
SQL
0 vote134 views1 answer
Soql more than today
SQL
0 vote132 views2 answers
Mysql disable foreign key checks
SQL
4 votes143 views2 answers
Show all database inside postgresql
SQL