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

3 votes278 views2 answers
How to load files in mysql
SQL
0 vote280 views1 answer
Date on SQL
SQL
2 votes325 views1 answer
Mysql select true or false
SQL
0 vote283 views1 answer
Fatal error: Uncaught PDOException: SQLSTATE[42S22]: Column not found: 1054 Unknown column 'autos_id' in 'field list' in
SQL
-1 vote292 views5 answers
Convert sql to linq query online
SQL
0 vote339 views1 answer
Mssql last day of month
SQL
3 votes264 views1 answer
Sql datetime as date
SQL
16 votes306 views6 answers
Mysql find duplicates in same table
SQL
12 votes307 views6 answers
How to install sqlite3 in python
SQL
0 vote272 views1 answer
Grepper sql workbench download
SQL