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 vote130 views1 answer
Provera dupliranih konatakata
SQL
0 vote102 views1 answer
Mql5 list all available symbols
SQL
1 vote185 views1 answer
How to select the nth row in a SQL database table?
SQL
3 votes110 views2 answers
How to load files in mysql
SQL
9 votes104 views2 answers
Default number in sql
SQL
0 vote114 views2 answers
Getting customers with no orders sql
SQL
-1 vote130 views1 answer
Mysql extract days
SQL
29 votes103 views5 answers
Mysql show table structure
SQL
0 vote121 views1 answer
SQLServerException.makeFromDatabaseError
SQL
0 vote113 views3 answers
Query string not ending with with vowels
SQL