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 vote129 views1 answer
Restart sql server command line linux
SQL
0 vote145 views1 answer
Influxdb clone measurement
SQL
0 vote158 views1 answer
Set root password mysql xampp
SQL
0 vote148 views1 answer
Mysql drop vs delete
SQL
0 vote153 views1 answer
Sub query in linq
SQL
26 votes383 views6 answers
Modify column name in sql
SQL
0 vote199 views1 answer
Ora 00001 error catch plsql
SQL
1 vote141 views4 answers
Fatal database postgres does not exist
SQL
1 vote119 views1 answer
Sql convert month name to number
SQL
1 vote142 views2 answers
Maximum number of tables in mysql
SQL