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

11 votes132 views2 answers
Oracle all source
SQL
0 vote145 views1 answer
Sql server Cost Fifo query
SQL
2 votes142 views2 answers
How to rename column name in sql server using query
SQL
4 votes136 views1 answer
Change nls_date_format
SQL
2 votes173 views1 answer
Mysql now format
SQL
1 vote127 views1 answer
Join first name and last name sql
SQL
2 votes132 views1 answer
Plsql block
SQL
-1 vote172 views4 answers
Sql view postgresql
SQL
0 vote136 views2 answers
Mysql to python pandas
SQL
13 votes160 views3 answers
Sql select from multiple tables without join
SQL