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 vote191 views1 answer
How to reset AI in sql
SQL
1 vote170 views1 answer
MYSQL HOT TO COUNT THE DURATION BETWEEN TWO DATES
SQL
0 vote205 views1 answer
Name '_mysql' is not defined
SQL
7 votes218 views2 answers
Mysql Public Key Retrieval is not allowed
SQL
1 vote209 views3 answers
Divide by zero error in sql
SQL
8 votes221 views2 answers
Replace string value in sql
SQL
0 vote216 views1 answer
Sql out file formate
SQL
7 votes208 views1 answer
Return insert results in POSTGRESQL
SQL
10 votes187 views4 answers
Primary key sql
SQL
0 vote185 views1 answer
Find largest table in mysql database
SQL