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 vote218 views1 answer
Query builder doctrien return sql
SQL
2 votes198 views1 answer
Sql alchemy or
SQL
7 votes214 views5 answers
Oracle alter table
SQL
2 votes218 views1 answer
Cast string to datetime mysql
SQL
0 vote238 views1 answer
Traccar mysql
SQL
2 votes212 views1 answer
Orcale index size
SQL
7 votes217 views4 answers
Lowest salary in sql
SQL
0 vote228 views1 answer
Disable database droping sql
SQL
0 vote210 views1 answer
Why we have to set the password for my sql server
SQL
0 vote225 views1 answer
Java nosql sort
SQL