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 vote164 views2 answers
Auto increment column in mysql query results
SQL
0 vote223 views1 answer
A network or instance-specific error sql server
SQL
1 vote186 views1 answer
Tsql random number
SQL
0 vote163 views1 answer
Raiserror nowait sql server
SQL
7 votes171 views2 answers
Get database size mysql
SQL
1 vote160 views1 answer
Postgres killing connections on db
SQL
0 vote168 views1 answer
Version_info, _mysql.version_info, _mysql.__file__ NameError: name '_mysql' is not defined
SQL
2 votes204 views1 answer
Select from array in psql
SQL
1 vote156 views1 answer
Scaffold mysql database
SQL
5 votes191 views1 answer
Ascending order and where in sql
SQL