Answers for "for loop pl sql"

SQL
1

for plsql

FOR contatore IN lower bound..upper bound
LOOP 
	...
END LOOP;
Posted by: Guest on March-09-2020
0

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)
Posted by: Guest on September-06-2021

Code answers related to "SQL"

Browse Popular Code Answers by Language