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 vote124 views1 answer
Como saber si tengo mysql instalado
SQL
0 vote109 views1 answer
Separator mysql
SQL
0 vote120 views1 answer
Close sql query vb.net
SQL
0 vote119 views1 answer
Mysql use password error
SQL
0 vote148 views2 answers
Compound operator in sql
SQL
13 votes127 views1 answer
Fetch first 5 rows in oracle sql developer
SQL
0 vote124 views1 answer
Oracle create job if not exists
SQL
0 vote140 views1 answer
Into operator in sql
SQL
1 vote140 views1 answer
Mysql month name extract
SQL
1 vote152 views1 answer
How do you use sql in you company
SQL