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 vote312 views1 answer
Mariadb LOAD DATA INFILE
SQL
56 votes629 views5 answers
Psql create user
SQL
13 votes335 views6 answers
Restart postgresql
SQL
0 vote288 views1 answer
Mysql offset from bottom
SQL
4 votes351 views2 answers
Tsql utf to local time
SQL
0 vote294 views1 answer
CREATE MULTIPLE FK
SQL
-1 vote367 views1 answer
Search all sql tables for a value
SQL
0 vote357 views3 answers
Postgres date difference seconds
SQL
0 vote372 views1 answer
Psql check table fields
SQL
0 vote389 views1 answer
How to find unique element in sql
SQL