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

2 votes336 views1 answer
Select * from table where name like
SQL
0 vote378 views1 answer
Oracle current date minus 1 day
SQL
0 vote312 views2 answers
SQLSTATE[HY000] [2054] The server requested authenticatio n method unknown to the client (SQL: select * from information_schema.tables where table_schema = todos_app and table_name = migrations and table_type = 'BASE TABLE')
SQL
1 vote401 views1 answer
How not to sort by average rating
SQL
0 vote380 views1 answer
Cahnge column name apex oracle
SQL
6 votes348 views3 answers
Commit in sql
SQL
0 vote349 views1 answer
. (provider: SQL Network Interfaces, error: 26 - Error Locating Server/Instance Specified) (.Net SqlClient Data Provider)
SQL
0 vote353 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
22 votes376 views3 answers
Year format in date mysql
SQL
3 votes326 views1 answer
Oracle user quota unlimited
SQL