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 vote213 views1 answer
Mysql workbench in ubuntu 14.04
SQL
28 votes189 views4 answers
Show tables mysql
SQL
1 vote247 views1 answer
Mysql current running queries
SQL
3 votes199 views1 answer
Mysql insert on dupèlicate
SQL
0 vote248 views1 answer
Sql server rtrim everything after character
SQL
0 vote250 views1 answer
Postgres extract number from string
SQL
1 vote141 views1 answer
Postgres division by zero
SQL
0 vote242 views2 answers
Sqlalchemy default value for column
SQL
0 vote142 views1 answer
Mssql view column data type
SQL
0 vote232 views1 answer
Drop domain postgresql
SQL