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

3 votes120 views1 answer
Uppercase and lowercase in sql
SQL
0 vote123 views1 answer
Wordpress database query change url
SQL
0 vote172 views1 answer
Example database query
SQL
0 vote121 views1 answer
Min:sec datediff mssql
SQL
0 vote135 views1 answer
Distance calculator from lat long sql query
SQL
0 vote113 views1 answer
Job for mysql.service failed because the control process exited with error code.
SQL
14 votes128 views5 answers
Sql oracle limit
SQL
0 vote242 views1 answer
How to delete duplicate rows in oracle
SQL
0 vote122 views1 answer
Inserting data into different tables at once in oracle sql
SQL
0 vote149 views1 answer
Hour differeence in mysql
SQL