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 vote195 views2 answers
Create row number in sql
SQL
0 vote198 views1 answer
Grant privileges of databse to user
SQL
0 vote248 views1 answer
Mysql faster delete
SQL
0 vote214 views2 answers
List all the items that have not been part of any purchase order. sql
SQL
0 vote206 views2 answers
How to count codition
SQL
8 votes189 views1 answer
Alter tablespace add datafile
SQL
1 vote213 views2 answers
DROP TABLes regardless of constraints
SQL
1 vote240 views1 answer
Join to find results not in another table
SQL
0 vote219 views1 answer
Sql script to remove default from column
SQL
1 vote240 views2 answers
Install sql server management studio ubuntu
SQL