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

2 votes334 views1 answer
Where clause for child record apex
SQL
7 votes259 views1 answer
Alter table add key sql
SQL
0 vote300 views1 answer
Sqlite commands
SQL
6 votes302 views4 answers
Delete table sqlite
SQL
0 vote297 views1 answer
Partitioning in oracle-base
SQL
0 vote295 views1 answer
Search In the Data using ObjectName
SQL
0 vote291 views4 answers
How to drop all tables in sql
SQL
1 vote313 views1 answer
Partition by sql server
SQL
18 votes316 views3 answers
Mysql add column default value
SQL
1 vote304 views2 answers
Create table if not exist
SQL