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 vote268 views1 answer
Sql get guid
SQL
0 vote291 views1 answer
A good way of running a SQL query in JDBC using a parameterized statement
SQL
3 votes253 views1 answer
What is having clause
SQL
1 vote291 views1 answer
Insert value to new table by joining 2 different tables
SQL
0 vote264 views2 answers
Mysql select date from datetime
SQL
0 vote304 views1 answer
Cartesian product sql
SQL
2 votes264 views3 answers
Postgres remove foreign key constraint
SQL
0 vote309 views10 answers
Sql statement checker corrector
SQL
0 vote269 views1 answer
Mysql set boolean default value
SQL
0 vote302 views2 answers
#1273 - Unknown collation: 'utf8mb4_0900_ai_ci'
SQL