General MySQL Oracle SQL Server

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

 

⇒ Use "FOR" Loop Statements in Oracle

⇐ Use "IF" Statements with Multiple Conditions in Oracle

⇑ Understanding PL/SQL Language Basics

⇑⇑ Oracle Database Tutorials

2018-07-13, 2688🔥, 0💬

General MySQL Oracle SQL Server