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 vote364 views1 answer
How to check which table has data in mysql
SQL
0 vote346 views1 answer
Show table structure mysql console
SQL
0 vote341 views3 answers
Get free card roblox
SQL
2 votes354 views1 answer
Guid to string sql
SQL
0 vote355 views1 answer
Mysql query to check record exists in database table or not
SQL
0 vote347 views1 answer
No suitable driver found for sqlite
SQL
0 vote335 views2 answers
How to start postgresql laravel
SQL
0 vote375 views1 answer
Split string by comma in sql server
SQL
0 vote345 views1 answer
Sql select min row
SQL
0 vote354 views1 answer
Create bdd mysql
SQL