Use "WHILE" Loop Statements in Oracle

Q

How To Use "WHILE" Loop Statements in Oracle?

✍: FYIcenter.com

A

If you have a block of codes to be executed repeatedly based a condition, you can use the "WHILE ... LOOP" statement. Here is a sample script on WHILE statements:

DECLARE
  total NUMBER;
BEGIN
  total := 0;
  WHILE total < 10 LOOP
    total := total+1;
  END LOOP;
  DBMS_OUTPUT.PUT_LINE('Total counts: ' || TO_CHAR(total));
END;

This script should print this:

Total counts: 10

 

Understanding PL/SQL Language Basics

⇒⇒Oracle Database Tutorials

2016-10-17, 198👍, 0💬