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 vote318 views1 answer
Array aggre distinct postgres
SQL
0 vote398 views1 answer
Postgresql powershell query
SQL
0 vote270 views1 answer
Mysql find the row ites of the hoghest value at on column
SQL
0 vote282 views1 answer
Executescalar in sql server
SQL
0 vote289 views1 answer
Intellij idea add mysql connector
SQL
0 vote282 views1 answer
MySQL get all previous date record
SQL
0 vote258 views1 answer
Check if a word appears at the end sql query
SQL
5 votes264 views1 answer
Ascending order and where in sql
SQL
2 votes259 views1 answer
Sql select min value from multiple columns
SQL
0 vote275 views1 answer
How to check xampp mysql password
SQL