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

1 vote275 views1 answer
Sql select where id not exists in another table
SQL
0 vote232 views1 answer
Mysql select top 2
SQL
0 vote301 views1 answer
Oracle sql add column auto generated value
SQL
16 votes330 views1 answer
Sqlserver add column to table
SQL
0 vote294 views1 answer
Convert polygon to text in mysql
SQL
6 votes296 views3 answers
Commit in sql
SQL
0 vote321 views1 answer
Cube oracle
SQL
0 vote296 views1 answer
Postgresql delete type
SQL
5 votes286 views1 answer
Oracle ORA-00054 origin
SQL
0 vote272 views1 answer
Mysql max number not returning correct value
SQL