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

7 votes178 views1 answer
Sql server management studio turn on line numbers
SQL
0 vote178 views1 answer
Mysql use password error
SQL
0 vote170 views1 answer
How to user id to show in from date to upto date in mssql server
SQL
49 votes195 views6 answers
Mysql add column to table
SQL
0 vote179 views1 answer
How to query all tables mysql at the same time
SQL
13 votes179 views2 answers
Mysql order by multiple columns
SQL
0 vote191 views1 answer
Login failed for user sql server
SQL
1 vote201 views2 answers
Mysql switch case
SQL
0 vote182 views2 answers
Timing sql queries
SQL
0 vote181 views1 answer
Mysql grant access to one database
SQL