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 vote94 views3 answers
Remove folders from remote git
SQL
0 vote101 views1 answer
How to find all children of a record with only parent ID in sql
SQL
9 votes99 views2 answers
Sql limit order by
SQL
0 vote102 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
0 vote103 views1 answer
Uncomment listen_address=localhost
SQL
1 vote112 views1 answer
Ubuntu mysql cannot connect to database server remote
SQL
0 vote94 views1 answer
MySQL FIND_IN_SET()
SQL
0 vote100 views1 answer
Postgres 11 add primary key
SQL
17 votes96 views4 answers
Show tables sql server
SQL
5 votes101 views1 answer
Sql add column after another
SQL