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

0 vote132 views1 answer
Postgres type equivalent to timespan c#
SQL
0 vote129 views1 answer
Sql DATE = GETDATE()
SQL
3 votes225 views4 answers
Sql interview questions
SQL
-1 vote149 views1 answer
Django.core.exceptions.ImproperlyConfigured: mysqlclient 1.3.13 or newer is required; you have 0.8.0.
SQL
2 votes183 views3 answers
Xampp mysql database not starting
SQL
0 vote138 views1 answer
Replace content value from old to new sql
SQL
13 votes144 views5 answers
Sql default
SQL
2 votes123 views2 answers
Postgresql date at timezone
SQL
0 vote158 views1 answer
Postgres duplicate database in same server while other session is using source database
SQL
0 vote133 views1 answer
Work around for mutating problem in Oracle Triggers. Please check it out.
SQL