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

1 vote140 views1 answer
Mysql f# examples
SQL
0 vote163 views2 answers
How to install psql in ubuntu
SQL
2 votes135 views2 answers
Mysql get time from datetime
SQL
1 vote128 views1 answer
Oracle start job
SQL
1 vote142 views1 answer
Declare variables sql
SQL
1 vote149 views1 answer
Mysql not supported auth mode
SQL
1 vote140 views1 answer
Sql week commencing date
SQL
0 vote133 views1 answer
Move table to a different schema
SQL
1 vote178 views1 answer
Psql client write to bash variable
SQL
1 vote129 views1 answer
Get last week data in mysql
SQL