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 vote197 views1 answer
Space not removing from column in sql
SQL
2 votes161 views1 answer
Can you use a where clause for a child query
SQL
0 vote176 views1 answer
Sql shell psql cannot enter password
SQL
3 votes185 views1 answer
Oracle get trigger ddl
SQL
4 votes171 views1 answer
Sql delete where in select
SQL
1 vote166 views1 answer
User privileges postgresql information_schema
SQL
2 votes168 views1 answer
How to find constraints on a table in oracle
SQL
0 vote227 views1 answer
Reset a table's identity column and remove test records
SQL
3 votes194 views1 answer
What is having
SQL
5 votes169 views2 answers
Oracle timestamp to date
SQL