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

0 vote105 views1 answer
Sql server query database space available
SQL
0 vote103 views2 answers
The metadata storage is not up to date, please run the sync-metadata-storage command to fix this issue.
SQL
0 vote102 views1 answer
Sqlalchemy query sql compiled
SQL
11 votes110 views4 answers
Update row in mysql
SQL
0 vote109 views2 answers
Py sqlite if entry exists
SQL
1 vote118 views1 answer
Load mysql dumb
SQL
1 vote111 views1 answer
Sql padd let with zeros
SQL
3 votes96 views1 answer
DB: in eloquent using sql
SQL
1 vote100 views1 answer
Mysql history command
SQL
0 vote55 views1 answer
Finish transaction sql
SQL