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

1 vote261 views1 answer
Pgsql sum switch case
SQL
5 votes198 views3 answers
Sql make column nullable
SQL
7 votes196 views2 answers
Execute mysql file
SQL
15 votes209 views4 answers
Pl sql
SQL
0 vote191 views1 answer
Oracle dynamic select into
SQL
0 vote197 views1 answer
Java mysql swing example
SQL
5 votes234 views2 answers
Create table mysql example auto_increment
SQL
0 vote234 views2 answers
Clauses in mysql
SQL
2 votes189 views1 answer
Anonymous block plsql
SQL
0 vote224 views1 answer
Sql basic commands
SQL