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 vote252 views1 answer
Psql: FATAL: Ident authentication failed for user "postgres"
SQL
0 vote248 views1 answer
Remove default constraint sql server
SQL
4 votes245 views2 answers
Tables in sql
SQL
10 votes282 views2 answers
Mysql drop database if exists
SQL
1 vote256 views1 answer
Convert to hexadecimal sql
SQL
19 votes258 views4 answers
Rename database in sql
SQL
15 votes255 views2 answers
Install mysql 8 ubuntu 18.04
SQL
9 votes259 views4 answers
How to create new user and database postgresql in ubuntu
SQL
0 vote240 views1 answer
Postgres add prefix to primary key
SQL
-1 vote268 views2 answers
SQL SELECT TOP Equivalent in oracal
SQL