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 vote205 views1 answer
Declare table variable
SQL
0 vote209 views2 answers
Advantages of stored procedures sql
SQL
1 vote214 views1 answer
Snowflake rename column name
SQL
1 vote203 views1 answer
GROUP BY clause; this is incompati
SQL
4 votes195 views2 answers
How to delete row in sql
SQL
0 vote220 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
6 votes269 views2 answers
Install psql mac
SQL
0 vote207 views1 answer
Oracle gather table statistics
SQL
0 vote211 views1 answer
SQL FROM-Klausel
SQL
1 vote221 views1 answer
Oracle split string
SQL