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, 1756🔥, 0💬
Popular Posts:
How To Connect ASP Pages to Oracle Servers in Oracle? If you are running Windows IIS Web server and ...
How To Convert Numeric Values to Integers in SQL Server Transact-SQL? Sometimes you need to round a ...
How To Use DATEADD() Function in SQL Server Transact-SQL? DATEADD() is a very useful function for ma...
How to connect SQL Server Management Studio Express to SQL Server 2005 Express in SQL Server? Once y...
Where to find MySQL database server tutorials? Here is a collection of tutorials, tips and FAQs for ...