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 vote88 views1 answer
Sql server select value large text
SQL
0 vote90 views4 answers
Sql year
SQL
-1 vote98 views1 answer
Mysql #1064 error
SQL
1 vote56 views1 answer
Insert and initialize a SQL column with value dependent on another column data
SQL
1 vote90 views1 answer
Wherein mysql
SQL
0 vote94 views1 answer
Influxdb clone measurement
SQL
0 vote102 views1 answer
Error code 1215 cannot add foreign key constraint
SQL
-1 vote114 views2 answers
Sql search all tables for attributes
SQL
0 vote127 views1 answer
Mysqldump: error:
SQL
0 vote92 views1 answer
Create column that already exists mysql
SQL