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

11 votes159 views1 answer
Mysql text type max length
SQL
0 vote171 views1 answer
Sql server for loop
SQL
1 vote202 views1 answer
How to check all scheduled jobs in oracle
SQL
1 vote159 views1 answer
Oracle list constraints
SQL
1 vote165 views1 answer
How to group by month using sql server
SQL
0 vote155 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
1 vote219 views1 answer
Find size of all DB's postgres
SQL
1 vote156 views2 answers
Pl sql case
SQL
0 vote161 views2 answers
How to update the multiple rows in sql
SQL
0 vote168 views1 answer
Sql update subtract value
SQL