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

12 votes206 views6 answers
How to install sqlite3 in python
SQL
1 vote203 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
1 vote206 views4 answers
Psql: error: FATAL: database "odoo" does not exist
SQL
0 vote210 views1 answer
Sqlalchemy query sql compiled
SQL
0 vote186 views1 answer
Double in sql server example
SQL
14 votes203 views5 answers
Sql oracle limit
SQL
1 vote220 views1 answer
Mariadb get column names from table
SQL
1 vote165 views1 answer
Enable mysql slow query log
SQL
4 votes205 views1 answer
Mysql not equal
SQL
0 vote189 views1 answer
INSERT INTO GBP Plus(Index Change) VALUES( AND((SELECT NUMINDEX FROM GBP WHERE ID>ID-1) - (SELECT NUMINDEX FROM GBP WHERE ID=ID ))
SQL