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 vote354 views1 answer
Dublicate row sql
SQL
2 votes161 views1 answer
Mysql list users on ubuntu
SQL
7 votes168 views2 answers
Show size database mysql
SQL
1 vote176 views1 answer
Altering the column name in MySQL to have a default value
SQL
1 vote211 views1 answer
Oracle columns table
SQL
0 vote185 views1 answer
How to alter length character varying postgres
SQL
0 vote189 views1 answer
Get last updated row sql server
SQL
0 vote157 views1 answer
Postgresql certain first 4 characters in string
SQL
3 votes182 views2 answers
Order by postgresql
SQL
1 vote167 views1 answer
Create another table from existing table sql oracle
SQL