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 vote260 views1 answer
This week mysql
SQL
0 vote296 views1 answer
Table structure in sql
SQL
3 votes281 views2 answers
Postgres inner join vs join
SQL
0 vote257 views2 answers
Android sqlite tutorial for beginners
SQL
0 vote260 views1 answer
Mysql_error replacement
SQL
0 vote262 views1 answer
Mysql select where field is a value
SQL
0 vote256 views1 answer
Update sqlite
SQL
0 vote256 views1 answer
Sub blocks in sql
SQL
3 votes257 views1 answer
How to check schema privileges in oracle
SQL
11 votes279 views2 answers
Mysql set safe mode off
SQL