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 vote191 views1 answer
Mssql check if date is greater than today
SQL
0 vote238 views2 answers
Suse stop MySQL
SQL
0 vote189 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
1 vote189 views1 answer
Complete output (15 lines): /bin/sh: 1: mysql_config: not found /bin/sh: 1: mariadb_config: not found /bin/sh: 1: mysql_config: not found Traceback (most recent call last): File "<string>", line 1, in <module> File "/tmp/pi
SQL
0 vote170 views1 answer
Mysql find foreign key references
SQL
0 vote211 views1 answer
Excel vba import data to sql server
SQL
25 votes211 views6 answers
How to change column name in mysql
SQL
1 vote203 views1 answer
Oracle split string
SQL
0 vote198 views1 answer
Whenever i'm passing data from datatable to sql table for large number in table it is storing with e+
SQL
3 votes189 views1 answer
Get current month last date in sql server
SQL