Pl/sql loop example

DECLARE
  l_counter NUMBER := 0;
BEGIN
  LOOP
    l_counter := l_counter + 1;
    IF l_counter > 3 THEN
      EXIT;
    END IF;
    dbms_output.put_line( 'Inside loop: ' || l_counter )  ;
  END LOOP;
  -- control resumes here after EXIT
  dbms_output.put_line( 'After loop: ' || l_counter );
END;Code language: SQL (Structured Query Language) (sql)

Source: oracletutorial.com

Similar codes

1 vote182 views3 answers
Getdate function in postgresql
SQL
0 vote221 views1 answer
Hibernate dialect property xml for mysql 8
SQL
51 votes242 views6 answers
Change column name sql
SQL
0 vote168 views1 answer
Postgres drop type
SQL
0 vote169 views1 answer
SQL Server Altering Column to be Unique
SQL
9 votes176 views5 answers
Sql limit
SQL
6 votes193 views2 answers
Mysqldump password in file
SQL
0 vote180 views1 answer
Query params sql insert python f string
SQL
0 vote179 views1 answer
Get yesterday date ISO in psql
SQL
1 vote171 views2 answers
Mysql extract month
SQL