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 vote163 views1 answer
Sql how to replace full stop
SQL
3 votes165 views1 answer
Postgres select max value
SQL
0 vote208 views1 answer
How to get column name in db from an sqlalchemy attribute model
SQL
0 vote109 views1 answer
Sql count how many times a value appears
SQL
5 votes160 views4 answers
Rollback to in sql
SQL
3 votes180 views2 answers
Synonym oracle
SQL
0 vote141 views1 answer
View acl table oracle
SQL
8 votes162 views1 answer
Oracle search text in all packages
SQL
4 votes144 views1 answer
Check database name postgresql
SQL
-1 vote161 views2 answers
Create temporary table sql
SQL