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 vote250 views1 answer
Will graphql replace sql
SQL
0 vote237 views1 answer
Check the size of the tables here ordered from the biggest size
SQL
7 votes238 views3 answers
Foreign key oracle
SQL
1 vote240 views1 answer
Mysql view current queries
SQL
-1 vote244 views5 answers
Operator in sql
SQL
0 vote226 views1 answer
Postgresql create table with boolean column
SQL
5 votes232 views1 answer
FSADeprecationWarning: SQLALCHEMY_TRACK_MODIFICATIONS adds significant overhead and will be disabled by default in the future. Set it to True or False to suppress this warning.
SQL
0 vote237 views1 answer
Alter owner in PostgreSQL
SQL
-1 vote251 views1 answer
Pl sql drop trigger
SQL
0 vote209 views1 answer
SQL server select to get sum of hours
SQL