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 vote98 views1 answer
Acutal month year
SQL
1 vote103 views3 answers
Getdate function in postgresql
SQL
0 vote100 views1 answer
Learn sqlite dart
SQL
1 vote104 views1 answer
Table information in sql server
SQL
1 vote102 views1 answer
SQL date part only of datetime
SQL
0 vote98 views1 answer
Change date format in oracle query
SQL
1 vote114 views1 answer
Sql server today minus n
SQL
0 vote112 views1 answer
Learnxinyminutes sql
SQL
7 votes112 views1 answer
Oracle reset sequence
SQL
0 vote92 views1 answer
Oracle 11g forget password
SQL