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`
2018-11-17, 713👍, 0💬
Popular Posts:
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...
How to download and install Microsoft SQL Server Management Studio Express in SQL Server? Microsoft ...
Where to find answers to frequently asked questions on Transaction Management: Commit or Rollback in...
Is SQL Server Transact-SQL case sensitive? No. Transact-SQL is not case sensitive. Like the standard...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...