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 vote369 views1 answer
Test sql query
SQL
1 vote379 views1 answer
SQl Server Versionen Releases und Build-Nummern
SQL
0 vote365 views1 answer
Mysql enter ubuntu
SQL
-1 vote383 views3 answers
My sql alter table
SQL
0 vote339 views1 answer
Sql count null as 0
SQL
-1 vote379 views3 answers
How to restart mysql in linux
SQL
0 vote362 views1 answer
Sql create text column limited values
SQL
10 votes354 views2 answers
Show tables in schema oracle
SQL
15 votes355 views4 answers
T-sql drop function if exists
SQL
7 votes377 views1 answer
Oracle alter sequence restart start with
SQL