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

2 votes289 views3 answers
Row number mysql
SQL
3 votes266 views1 answer
Postgresql if null then 0
SQL
1 vote242 views1 answer
Delete mysql from mac
SQL
1 vote271 views1 answer
Add many column to sap iq table
SQL
2 votes299 views1 answer
Python sql
SQL
0 vote247 views1 answer
Sql cheetsheet
SQL
0 vote220 views1 answer
Grant owner postgresql
SQL
0 vote275 views1 answer
Mariadb set vertical output format
SQL
1 vote259 views1 answer
ERROR 1290 (HY000): The MySQL server is running with the --secure-file-priv option so it cannot execute this statement
SQL
0 vote315 views1 answer
Trigger
SQL