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 vote126 views1 answer
Check index sql server
SQL
0 vote147 views1 answer
TSQL convert csv to table
SQL
2 votes133 views2 answers
Sql percentage
SQL
0 vote144 views1 answer
How to get distinct sets of rows using SQL (Oracle)?
SQL
1 vote123 views1 answer
Hexadec to sql REDSHIFT
SQL
1 vote126 views1 answer
Crontab every month
SQL
2 votes167 views1 answer
How to select from mssql
SQL
-1 vote182 views5 answers
Left join sql
SQL
0 vote137 views1 answer
Order by in codeigniter query builder
SQL
0 vote152 views1 answer
InnoDB: Setting file 'C:\xampp\mysql\data\ibtmp1' size to 12 MB. Physically writing the file full; Please wait ...
SQL