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

1 vote210 views1 answer
Function difference_in_hours(timestamp with time zone) does not exist
SQL
6 votes187 views2 answers
Mysql interval 1 day
SQL
10 votes178 views1 answer
Dba_dependencies
SQL
0 vote178 views1 answer
Sql server datetime to string
SQL
0 vote213 views1 answer
Oracle list dblink
SQL
0 vote176 views1 answer
An exception occurred while executing a transact-sql statement or batch user,group or role already
SQL
0 vote174 views1 answer
Sql server: how to assign value to table variable returned from function
SQL
0 vote180 views1 answer
How to find columns with null values in sql
SQL
0 vote216 views2 answers
Sql update multiple tables
SQL
1 vote200 views2 answers
Postgresql truncate cascade restart identity
SQL