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

11 votes111 views1 answer
Reset identity sql server
SQL
0 vote326 views1 answer
Dublicate row sql
SQL
0 vote159 views1 answer
Sql select column names starting with
SQL
0 vote151 views2 answers
Csv into data postgres
SQL
9 votes152 views4 answers
Mysql show table fields
SQL
0 vote153 views2 answers
Psql commande \gset
SQL
0 vote186 views1 answer
Mysql backup query
SQL
0 vote154 views1 answer
Insert or update sql query
SQL
34 votes161 views5 answers
Oracle alter table add column
SQL
1 vote154 views1 answer
How to remove identity from a column in sql server
SQL