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

244 votes477 views14 answers
Sql n insert
SQL
0 vote231 views1 answer
Sql server rtrim everything after character
SQL
2 votes181 views1 answer
Mysql change data type of column
SQL
0 vote182 views1 answer
Sql select upcoming birthdays
SQL
0 vote178 views1 answer
Add plugins to mysql workbench
SQL
1 vote211 views1 answer
Mysql search like order by best match
SQL
2 votes223 views1 answer
Postgresql transaction
SQL
37 votes223 views5 answers
FIND DUPLICATES IN COLUMN SQL
SQL
1 vote194 views2 answers
Create a unqie constraint mysql
SQL
0 vote205 views1 answer
Error: com.mysql.cj.jdbc.Driver not loaded. Are you sure you've included the correct jdbc driver in :jdbc_driver_library?
SQL