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 vote282 views2 answers
MySQL said: Authentication plugin 'caching_sha2_password' cannot be loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2): image not found
SQL
6 votes302 views1 answer
Oracle rank
SQL
0 vote282 views2 answers
Error while setting value 'ONLY_FULL_GROUP_BY,ALLOW_INVALID_DATES,ERROR_FOR_DIVISION_BY_ZERO,NO_AUTO_CREATE_USER,NO_ENGINE_SUBSTITUTION' to 'sql_mode'
SQL
2 votes289 views1 answer
Add default sql server
SQL
3 votes281 views1 answer
Convert sqlite table to pandas dataframe
SQL
27 votes287 views4 answers
Get all tables with column name sql
SQL
2 votes290 views3 answers
Oracle show column of table
SQL
1 vote309 views1 answer
Avg mysql
SQL
5 votes294 views1 answer
Mysql created at yesterdau
SQL
6 votes278 views1 answer
Oracle rank() over (partition)
SQL