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 vote137 views1 answer
SQL server select to get sum of hours
SQL
1 vote142 views1 answer
Sometimes i cant edit sql developer
SQL
0 vote141 views2 answers
Tsql row number
SQL
0 vote143 views1 answer
Parent: [Error: SQLITE_READONLY: attempt to write a readonly database] {
SQL
0 vote113 views1 answer
Postgresql add leading zeros
SQL
0 vote179 views1 answer
Month mysql
SQL
16 votes144 views4 answers
Ascending order mysql
SQL
0 vote100 views1 answer
Sqlalchemy filter relationship
SQL
11 votes152 views1 answer
Sql insert multiple rows from select
SQL
8 votes164 views1 answer
Database backup in mysql server recovery
SQL