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

2 votes304 views3 answers
Application.properties spring boot mysql
SQL
1 vote317 views1 answer
Substr sql last character
SQL
0 vote310 views1 answer
Not between mysql
SQL
27 votes339 views6 answers
Sql update record
SQL
1 vote325 views1 answer
Select if then postgresql
SQL
0 vote359 views1 answer
Sql create and grant user access to database
SQL
2 votes374 views1 answer
Mysql shell insert into
SQL
0 vote352 views2 answers
Compound operator in sql
SQL
1 vote344 views1 answer
How to ckeck that email is present in databse in mysqli
SQL
-1 vote315 views1 answer
MySQL said: Documentation #1010 - Error dropping database errno: 39 "Directory not empty")
SQL