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

1 vote175 views1 answer
Mysql pretty date format
SQL
-1 vote183 views3 answers
Compute age mysql
SQL
2 votes168 views4 answers
How to find 2nd highest salary in mysql
SQL
0 vote167 views2 answers
CREATE TABLE researcher ( researcherid serial PRIMARY KEY, name text );
SQL
4 votes172 views1 answer
Restart for pg_hba.conf file
SQL
2 votes168 views1 answer
Sql count having
SQL
0 vote160 views1 answer
Restore backup "text" postgresql command line
SQL
0 vote153 views1 answer
Sql examples from your work
SQL
0 vote170 views1 answer
Get who is hired in month in sql
SQL
0 vote178 views1 answer
Create table as select sql server error
SQL