Collections:
Types of Execution Flow Control Statements in Oracle
What Are the Execution Control Statements in Oracle?
✍: FYIcenter.com
PL/SQL supports three groups of execution control statements:
The script below shows some execution control statements:
DECLARE total NUMBER; BEGIN total := 0; LOOP total := total+1; IF total >= 10 THEN GOTO print; END IF; END LOOP; <<;print>> DBMS_OUTPUT.PUT_LINE('Total counts: ' || TO_CHAR(total)); END;
This script should print this:
Total counts: 10`
⇒ Use "IF" Statements with Multiple Conditions in Oracle
⇐ Convert Character Types to Numeric Types in Oracle
2018-11-17, 1396🔥, 0💬
Popular Posts:
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
Where to find answers to frequently asked questions I am new to Oracle database. Here is a list of f...
How to download and install the scaled-down database AdventureWorksLT in SQL Server? If you want to ...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...