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

5 votes384 views2 answers
Functions
SQL
0 vote347 views2 answers
Plan d'exécution requete oracle autotracer
SQL
1 vote360 views1 answer
Oracle grant on all tables in schema
SQL
2 votes335 views1 answer
Alter table add multiple columns postgresql
SQL
0 vote377 views2 answers
Amazon linux postgresql client
SQL
0 vote338 views1 answer
Sql transact create cursor with dynamic tables
SQL
0 vote403 views1 answer
Alternative for LIMIT sql
SQL
0 vote355 views1 answer
Table or view does not exist
SQL
2 votes368 views3 answers
Postgres create view
SQL
0 vote342 views1 answer
Php delete database
SQL