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 vote116 views1 answer
Get cpu details sql
SQL
1 vote123 views1 answer
Check if mysql is installed
SQL
2 votes114 views1 answer
Oracle drop sequence if exists
SQL
1 vote106 views10 answers
Stack overflow
SQL
1 vote115 views1 answer
Postgresql datetrunc too slow
SQL
2 votes76 views1 answer
Foreign key example in dbms
SQL
0 vote115 views1 answer
Load SQLite in Jupyter Notebook together with the access to the file
SQL
0 vote121 views1 answer
Sql tablo sp
SQL
2 votes115 views1 answer
Oracle virtual column
SQL
0 vote117 views1 answer
Except in sql alchemy
SQL