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

8 votes332 views1 answer
How to remove tables from postgresql
SQL
6 votes319 views2 answers
Sql display max value
SQL
0 vote352 views1 answer
Sql multiple into
SQL
0 vote343 views1 answer
Sql gather statistics to increase performance
SQL
0 vote316 views1 answer
Update using case in mysql
SQL
0 vote265 views1 answer
Oracle last user logon
SQL
22 votes400 views1 answer
Mysql workbench
SQL
-1 vote353 views3 answers
Unknown collation: 'utf8mb4_0900_ai_ci'
SQL
6 votes306 views3 answers
Mysql server is not starting xampp
SQL
0 vote312 views2 answers
Sqlite
SQL