Collections:
Execution Flow Control Statements in Oracle
What Are the Execution Flow Control Statements in Oracle?
✍: FYIcenter.com
PL/SQL supports three groups of execution control statements:
The script below shows execution control statements:
SQL> set serveroutput on; SQL> DECLARE 2 total NUMBER; 3 BEGIN 4 total := 0; 5 LOOP 6 total := total+1; 7 IF total >= 10 THEN 8 GOTO print; 9 END IF; 10 END LOOP; 11 <<print>> 12 DBMS_OUTPUT.PUT_LINE('Total counts: ' 13 || TO_CHAR(total)); 14 END; 15 / Total counts: 10
This sample script shows you how to use LOOP, IF, and GOTO statements.
⇒ Use SQL Statements in PL/SQL in Oracle
⇐ Data Types Supported in PL/SQL in Oracle
2019-03-27, 1992🔥, 1💬
Popular Posts:
Why I Can Not Enter 0.001 Second in DATETIME values in SQL Server Transact-SQL? If you enter millise...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
How To Convert Numeric Expression Data Types using the CAST() Function in SQL Server Transact-SQL? I...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...