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 vote142 views2 answers
Update information in a mysql column
SQL
0 vote192 views1 answer
Sql to excel pgadmin
SQL
0 vote152 views1 answer
Sauvegarde complète my sql
SQL
0 vote148 views1 answer
Oracle last connection
SQL
34 votes202 views6 answers
Alter table add foreign key mysql
SQL
5 votes144 views1 answer
Oracle scan source ddl
SQL
0 vote155 views1 answer
Mod in sql
SQL
1 vote149 views6 answers
In sql
SQL
0 vote143 views1 answer
Learn sqlite dart
SQL
1 vote171 views1 answer
Lpad function in sql oracle
SQL