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

3 votes101 views1 answer
Uppercase and lowercase in sql
SQL
0 vote152 views1 answer
Bigrock database connection string
SQL
3 votes128 views1 answer
Apex set debug level
SQL
-1 vote110 views5 answers
Convert sql to linq query online
SQL
0 vote102 views1 answer
Set default value now() date
SQL
2 votes102 views1 answer
Get first n letter of department name in sql
SQL
1 vote113 views1 answer
Mysql return if it contains
SQL
2 votes114 views2 answers
Mysql alter column default
SQL
2 votes94 views1 answer
Sqlplus clear screen
SQL
0 vote111 views1 answer
Yesql
SQL