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 vote167 views1 answer
Sql sort column by date
SQL
1 vote106 views1 answer
Oracle boolean to varchar
SQL
0 vote147 views1 answer
Sql developer connect to sql server
SQL
9 votes141 views4 answers
SQL Date Format
SQL
0 vote115 views1 answer
Mysql insert with foreign key
SQL
2 votes193 views3 answers
3 days back in sql server
SQL
2 votes156 views1 answer
Query any digits record
SQL
0 vote163 views1 answer
Add sqlcmd to path linux
SQL
0 vote154 views1 answer
Sql select inside select sub query
SQL
0 vote145 views1 answer
Drop tables from local database postgres pgadmin
SQL