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 vote275 views1 answer
The package java.sql is not accessible
SQL
0 vote110 views1 answer
Sql declare variable single line
SQL
0 vote107 views1 answer
Sum sqlserver
SQL
4 votes101 views2 answers
Sql server date now
SQL
1 vote123 views1 answer
Oracle sequence last_number
SQL
0 vote115 views1 answer
MySQL - Enabling the Event Scheduler
SQL
1 vote103 views3 answers
Postgresql connect to database
SQL
3 votes116 views3 answers
Start postgresql ubuntu
SQL
4 votes130 views1 answer
Is there any command to change postgres password
SQL
0 vote110 views4 answers
Database stuck at restoring state
SQL