Plsql while

DECLARE 
   a number(2) := 10; 
BEGIN 
   WHILE a < 20 LOOP 
      dbms_output.put_line('value of a: ' || a); 
      a := a + 1; 
   END LOOP; 
END; 
/

-1

Similar codes

11 votes164 views2 answers
Set default column value sql
SQL
4 votes143 views4 answers
Pl sql output
SQL
1 vote132 views1 answer
Restart identity postgresql
SQL
0 vote141 views1 answer
T sql return on letters only
SQL
0 vote139 views1 answer
Mysql date time string format for marshmellow field schema
SQL
1 vote129 views1 answer
Oracle db create new schema
SQL
1 vote118 views1 answer
Firebase bigquery cloud message
SQL
0 vote144 views1 answer
Mysql limit order by
SQL
2 votes144 views2 answers
Postgres add column integer
SQL
-1 vote120 views2 answers
How to select the lowest values from table per client sql
SQL