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

3 votes340 views1 answer
Sql select second max
SQL
8 votes269 views2 answers
Grant all privileges database postgres to user
SQL
0 vote259 views1 answer
Limit and offset in stored procedure mssql
SQL
0 vote263 views1 answer
Knex last insert id mysql
SQL
0 vote267 views2 answers
How to delete the rows with null values in mysql
SQL
1 vote262 views1 answer
Float precision in psql
SQL
-1 vote308 views1 answer
Difference berween database and data base management system
SQL
3 votes266 views2 answers
Df to sql pandas sql achemy
SQL
13 votes265 views2 answers
Sql count distinct group by
SQL
1 vote266 views1 answer
Describe table in sql
SQL