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 vote358 views1 answer
ORACLE PARSE STRING
SQL
1 vote363 views1 answer
Sql padd let with zeros
SQL
2 votes366 views1 answer
How to find constraints on a table in oracle
SQL
0 vote379 views1 answer
How to find total working hour in sql
SQL
0 vote342 views1 answer
Nueva tabla mysql
SQL
9 votes367 views1 answer
Mysql check date range
SQL
0 vote342 views1 answer
Sql query to delete row by id
SQL
1 vote396 views1 answer
Sql view where tables have same column name combine results
SQL
0 vote359 views1 answer
Mysql join same table multiple times group by
SQL
0 vote347 views2 answers
Insert into
SQL