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 vote242 views1 answer
Tsql pad left
SQL
0 vote234 views1 answer
Call rest api from postgresql
SQL
0 vote238 views1 answer
Java spring boot connect to sql server
SQL
5 votes253 views1 answer
How to get all table names in sql query
SQL
0 vote221 views1 answer
Mysql cdn link
SQL
0 vote227 views1 answer
Adding primery key constraint to a column
SQL
0 vote237 views1 answer
Difference between db.query and db.execute
SQL
0 vote247 views1 answer
Oracle query to find schema you are working on
SQL
1 vote243 views1 answer
Oracle repeat_interval 5 minutes
SQL
93 votes275 views4 answers
Create database postgres
SQL