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 vote236 views1 answer
Call object contructor and call methods of object
SQL
0 vote201 views1 answer
Mysql database is not starting in xampp
SQL
-1 vote206 views1 answer
What is in operator
SQL
0 vote216 views1 answer
Plsql find location of procedure
SQL
0 vote222 views1 answer
Foreign key multiple columns
SQL
0 vote220 views1 answer
How many rows affected in sqllite
SQL
1 vote248 views1 answer
Db.Database.SqlQuery
SQL
0 vote214 views1 answer
Sqlite higher or equal
SQL
0 vote209 views1 answer
Sql xampp gabungan nama awal dan akhir
SQL
0 vote229 views1 answer
Convert uniqueidentifier to varchar in sql
SQL