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 vote265 views1 answer
Update sql join multiple tables
SQL
0 vote351 views1 answer
Gcloud sql list databases
SQL
1 vote315 views2 answers
Mysql remove first and last character from string
SQL
0 vote303 views1 answer
Order by monthly in sql
SQL
6 votes318 views4 answers
Delete table sqlite
SQL
3 votes317 views2 answers
Monthname sql
SQL
0 vote338 views1 answer
Default order by in mysql
SQL
0 vote322 views2 answers
Mysql create table if not exists
SQL
0 vote318 views4 answers
How to connect form to database
SQL
0 vote308 views1 answer
How to use lower case in mysql
SQL