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

0 vote299 views1 answer
Mysql loop through databases and execute query
SQL
0 vote338 views1 answer
How to convert external table to managed table in hive
SQL
0 vote323 views2 answers
Amazon linux postgresql client
SQL
0 vote291 views2 answers
Sql update multiple tables
SQL
0 vote322 views1 answer
Firebase sql
SQL
1 vote236 views1 answer
File /etc/init.d/mysql not exists
SQL
0 vote287 views1 answer
Mysql cdn link
SQL
0 vote282 views2 answers
Postgresql get long running queries
SQL
0 vote289 views1 answer
Execute a stored procedure in another stored procedure in SQL server
SQL
16 votes301 views2 answers
Sql exists
SQL