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 vote190 views1 answer
Mysql db dump restore max file size issue
SQL
0 vote180 views1 answer
Set a value by excuting stored procedure
SQL
0 vote191 views1 answer
Sql script to remove default from column
SQL
0 vote185 views1 answer
How to find columns with null values in sql
SQL
-1 vote236 views3 answers
MAKE TABLE FIT in oracle sql
SQL
0 vote306 views1 answer
Duplicate table: 7 ERROR: relation "migrations" already exists (SQL: create table "migrations" ("id" serial primary key not null, "migration" varchar(255) not null, "batch" integer not null))
SQL
0 vote248 views1 answer
Php insert null mysql
SQL
0 vote175 views1 answer
Mysql show category once count how many products
SQL
0 vote172 views1 answer
Sqlite to csv statement
SQL
0 vote183 views1 answer
Select other columns with distinct
SQL