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 vote258 views1 answer
Sql anywhere create procedure
SQL
0 vote243 views1 answer
Mysql xampp reset root password
SQL
0 vote252 views1 answer
Automatically update database last seen datetime in sql
SQL
0 vote245 views1 answer
Mysql max connections exceeded max_connections_per_hour
SQL
2 votes257 views1 answer
Sql alchemy or
SQL
10 votes264 views6 answers
Mysql delete duplicates
SQL
5 votes284 views2 answers
Postgresql add not null constraint
SQL
3 votes265 views1 answer
Define REGEXP?
SQL
0 vote252 views1 answer
Calculate date and convert to yearsmysql
SQL
0 vote237 views1 answer
MySQLdb._exceptions.ProgrammingError: (1146, "Table 'edxapp.app_feedback feedback category' doesn't exist")
SQL