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 vote231 views1 answer
Add timestamp column to existing table ms sql server
SQL
6 votes237 views1 answer
T-sql test if table exists
SQL
0 vote251 views1 answer
How do I insert a blob in SQL?
SQL
0 vote221 views1 answer
Sql last 7 days
SQL
3 votes224 views3 answers
Create table in microsoft sql server
SQL
0 vote233 views1 answer
Alter fedora mysql 8.0 user
SQL
1 vote218 views1 answer
Using SQL in rails migration
SQL
0 vote217 views1 answer
How to reset AI in sql
SQL
1 vote239 views1 answer
Cannot drop database because it is currently in use
SQL
2 votes220 views1 answer
Oracle cpu per session
SQL