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

7 votes137 views1 answer
Sql server management studio turn on line numbers
SQL
1 vote126 views1 answer
Drop df constraint sql server
SQL
0 vote136 views1 answer
Get time component of datetime sql
SQL
0 vote136 views1 answer
Mariadb alter table add column if not exists example
SQL
0 vote141 views1 answer
Sql query to get contact form 7 fields
SQL
0 vote152 views1 answer
Find how many tables in database sql query
SQL
1 vote124 views1 answer
How to select random rows from table
SQL
1 vote142 views1 answer
Full sql mode
SQL
0 vote139 views1 answer
Count characters of string mysql
SQL
0 vote131 views1 answer
Linebreak sql
SQL