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 vote110 views2 answers
Mysql order by date asc null last
SQL
1 vote120 views1 answer
Mysql count multiple columns in one query
SQL
4 votes116 views2 answers
Oracle set date format
SQL
0 vote125 views1 answer
Drop column from local database postgres pgadmin
SQL
0 vote129 views1 answer
Fetcht he leftmost word in a comma separated string in sql
SQL
0 vote129 views1 answer
Mysql custom sort order
SQL
9 votes112 views3 answers
Mysql get last id
SQL
0 vote110 views1 answer
Pl sql join 3 tables
SQL
0 vote138 views1 answer
Check constraint is violated
SQL
6 votes119 views2 answers
Stored procedure to delete data from table in mysql
SQL