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 vote313 views1 answer
Java spring boot connect to sql server
SQL
5 votes368 views2 answers
Oracle find all tables with column name
SQL
11 votes340 views2 answers
Having clause
SQL
0 vote363 views1 answer
Sql on-premises
SQL
7 votes372 views4 answers
Mysql delete older duplicates
SQL
1 vote367 views1 answer
Quit mysql
SQL
0 vote358 views1 answer
Sql find leading space
SQL
-1 vote366 views2 answers
Postgresql user permissions to database
SQL
0 vote344 views1 answer
Excute raw query
SQL
2 votes364 views1 answer
Codeigniter print last sql query
SQL