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

20 votes253 views5 answers
Mysql reset auto increment to 1
SQL
0 vote280 views1 answer
Sql count matching group by
SQL
3 votes335 views1 answer
Oracle list invalid password logon denied
SQL
0 vote253 views1 answer
How to reset AI in sql
SQL
0 vote281 views1 answer
Authentication in sql server
SQL
-1 vote295 views3 answers
MySQL shutdown unexpectedly
SQL
0 vote276 views1 answer
Connecting mySQL to STS
SQL
11 votes288 views6 answers
Distinct sql
SQL
-1 vote275 views1 answer
Sql oracle take only last results
SQL
0 vote274 views1 answer
Sql getdate minus 1 day without time
SQL