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

15 votes273 views3 answers
Create table with primary key auto increment in sql
SQL
6 votes264 views3 answers
Mysql remove user privileges
SQL
0 vote205 views1 answer
Postgres multiple left join causing duplicates jsonb_agg
SQL
0 vote226 views1 answer
Delete a record from a table sqlite3
SQL
0 vote219 views1 answer
Foreign key multiple columns
SQL
2 votes143 views1 answer
Mysql admin u root p password change password
SQL
0 vote231 views1 answer
Influxdb list all tags for a measurement
SQL
0 vote206 views1 answer
Value of sold product using having and group by in sql
SQL
2 votes203 views1 answer
Q operator in plsql
SQL
3 votes198 views2 answers
Oracle sql truncate table
SQL