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, 1379🔥, 0💬
Popular Posts:
How To Create a Dynamic Cursor with the DYNAMIC Option in SQL Server Transact-SQL? If the underlying...
How To Round a Numeric Value To a Specific Precision in SQL Server Transact-SQL? Sometimes you need ...
How to run Queries with SQL Server Management Studio Express in SQL Server? 1. Launch and connect SQ...
How To Insert New Line Characters into Strings in SQL Server Transact-SQL? If you want to break a st...
What Is an Oracle Instance in Oracle? Every running Oracle database is associated with an Oracle ins...