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 vote358 views1 answer
Create query in where clasue
SQL
1 vote350 views1 answer
Oracle lock user
SQL
6 votes404 views2 answers
Subtr Oracle ?
SQL
0 vote470 views1 answer
How to rename a database in tsql
SQL
0 vote354 views1 answer
Mssql view column data type
SQL
2 votes368 views1 answer
How to find constraints on a table in oracle
SQL
0 vote355 views1 answer
Create function syntax sql server
SQL
1 vote366 views1 answer
Psql search table
SQL
0 vote382 views1 answer
Sql select upcoming birthdays
SQL
-1 vote387 views1 answer
Sql select data from one database and insert into a different database
SQL