How To Use "WHILE" Statements

Q

How To Use "WHILE" Statements? - Oracle DBA FAQ - Understanding PL/SQL Language Basics

✍: 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

2007-04-29, 4393👍, 0💬