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

14 votes323 views3 answers
Delete all records from table except sql
SQL
0 vote332 views1 answer
Sql query wordpress export post
SQL
0 vote305 views1 answer
Sql query to get column names and data types in sql server
SQL
0 vote288 views1 answer
Http://challenge01.root-me.org:58036/wsasd
SQL
0 vote339 views1 answer
Cartesian product sql
SQL
1 vote309 views1 answer
Drush sql-dump
SQL
0 vote331 views1 answer
Sql query to force the database to be drop
SQL
0 vote361 views1 answer
Insert into using contant values and source table columns with sql
SQL
0 vote320 views1 answer
Oracle for loop on list
SQL
24 votes338 views4 answers
Postgres delete database
SQL