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 vote274 views1 answer
How to find top 3 salary in sql
SQL
1 vote268 views3 answers
String to int mysql
SQL
1 vote301 views1 answer
Sql string function update replace
SQL
4 votes282 views2 answers
Bulk kill mysql processlist
SQL
0 vote283 views3 answers
Average salary in sql
SQL
11 votes269 views2 answers
Having keyword sql
SQL
0 vote283 views1 answer
Substract variable amount of minutes from timestamp postgresql
SQL
2 votes293 views5 answers
SQL trigger
SQL
2 votes346 views1 answer
Tcl in sql
SQL
0 vote285 views1 answer
Mysql preg replace
SQL