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 vote193 views1 answer
Sql to mongodb query converter
SQL
0 vote216 views1 answer
SQL joins in python
SQL
0 vote189 views1 answer
Export partttion and import in oracle
SQL
0 vote203 views1 answer
Closure in sql
SQL
0 vote186 views1 answer
MySQL error code 2068
SQL
0 vote199 views1 answer
Trigger stock phpmyadmin output message
SQL
0 vote178 views1 answer
Oracle execute package dblink
SQL
0 vote200 views1 answer
ORA-13717
SQL
0 vote189 views2 answers
Sql server select first day of previous year
SQL
0 vote189 views1 answer
Get the First and Last Word from a String or Sentence
SQL