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 vote161 views1 answer
Postgres - Login and connect as default user
SQL
3 votes155 views2 answers
Truncate all tables
SQL
1 vote163 views1 answer
Describe table in sql
SQL
2 votes146 views1 answer
Oracle calculated column
SQL
3 votes136 views1 answer
Sql timestamp to date
SQL
0 vote143 views1 answer
Check connections to database postgres
SQL
1 vote163 views1 answer
Sql server: query to find out all the places where the table is used
SQL
11 votes152 views3 answers
Sql_mode=only_full_group_by
SQL
0 vote152 views1 answer
Drop specific row postgresql
SQL
1 vote149 views1 answer
Window function mysql
SQL