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 vote352 views1 answer
Pl sql insert into table
SQL
5 votes312 views1 answer
Mongodb vs
SQL
1 vote344 views1 answer
Show table status command in mysql
SQL
0 vote360 views1 answer
Mysql join table with a text columns with ids splited by char
SQL
-1 vote375 views1 answer
How to change the auto increment in existing table mysql
SQL
4 votes368 views2 answers
Postgresql default value
SQL
1 vote351 views1 answer
How to between in sql
SQL
0 vote386 views1 answer
Get last inserted primary key
SQL
0 vote300 views1 answer
Mitigation of sql injection
SQL
11 votes342 views2 answers
Having in sql
SQL