Breaking News: Grepper is joining You.com. Read the official announcement!

pl/sql loop example

Add Answer

Unusual Unicorn answered on September 6, 2021 Popularity 10/10 Helpfulness 5/10

answer pl/sql loop example

related for loop in pl/sql

related loop example PL/SQL

related for loop pl/sql

pl/sql loop example

Comment

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)

Popularity 10/10 Helpfulness 5/10 Language sql

Source: www.oracletutorial.com

Tags: sql

Link to this answer
Share Copy Link

Contributed on Sep 06 2021

Unusual Unicorn

0 Answers Avg Quality 2/10

Closely Related Answers

for loop in pl/sql

Comment

DECLARE 
   a number(2) ; 
BEGIN 
   FOR a IN REVERSE 10 .. 20 LOOP 
      dbms_output.put_line('value of a: ' || a); 
   END LOOP; 
END;

Popularity 9/10 Helpfulness 5/10 Language whatever

Source: Grepper

Tags: for-loop for-loo

Link to this answer
Share Copy Link

Contributed on Jan 26 2023

Odd Orangutan

0 Answers Avg Quality 2/10

loop example PL/SQL

Comment

DECLARE
   n NUMBER;
   average NUMBER :=0 ;
   sum NUMBER :=0 ;
   count NUMBER :=0 ;
BEGIN
   -- Take input from user
   n := &input_number;
   WHILE(n<>0)
       LOOP
           -- Increment count to find total elements
           count := count+1;
           -- Sum of elements entered
           sum := sum+n;
           -- Take input from user
           n := &input_number;
       END LOOP;
   -- Average calculation
   average := sum/count;
   DBMS_OUTPUT.PUT_LINE(‘Average of entered numbers is ’||average);
END;

Popularity 9/10 Helpfulness 4/10 Language sql

Source: www.interviewbit.com

Tags: sql

Link to this answer
Share Copy Link

Contributed on Oct 16 2022

Yabaduga

0 Answers Avg Quality 2/10

for loop pl/sql

Comment

--syntax
FOR loop_counter IN [REVERSE] lowest_number..highest_number
LOOP
   {...statements...}
END LOOP;
--example
FOR Lcntr IN 1..20
LOOP
   LCalc := Lcntr * 31;
END LOOP;

Popularity 3/10 Helpfulness 2/10 Language sql

Source: www.techonthenet.com

Tags: for-loop sql

Link to this answer
Share Copy Link

Contributed on Apr 17 2024

fradale2000

0 Answers Avg Quality 2/10

pl/sql loop example

Contents

More Related Answers

pl/sql loop example

Closely Related Answers

for loop in pl/sql

loop example PL/SQL

for loop pl/sql

Grepper

Documentation

Social

Legal

Contact

Oops, You will need to install Grepper and log-in to perform this action.