Collections:
Use "IF" Statements with Multiple Conditions in Oracle
How To Use "IF" Statements on Multiple Conditions in Oracle?
✍: FYIcenter.com
If you have multiple blocks of codes to be executed based on different conditions, you can use the "IF ... ELSIF" statement. Here is a sample script on IF statements:
DECLARE day VARCHAR2; BEGIN day := 'SUNDAY'; IF day = 'THURSDAY' THEN DBMS_OUTPUT.PUT_LINE('Checking log files.'); ELSIF day = 'TUESDAY' THEN DBMS_OUTPUT.PUT_LINE('Helping developers.'); ELSIF day = 'FRIDAY' THEN DBMS_OUTPUT.PUT_LINE('Rebuild indexes.'); ELSE DBMS_OUTPUT.PUT_LINE('Reading some papers.'); END IF; END;
This script should print this:
Reading some papers.
⇒ Use "WHILE" Loop Statements in Oracle
⇐ Types of Execution Flow Control Statements in Oracle
2018-07-13, 1485🔥, 0💬
Popular Posts:
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
What are binary literals supported in SQL Server Transact-SQL? Binary literals in Transact-SQL are s...
Where to find answers to frequently asked questions on Downloading and Installing SQL Server 2005 Ex...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
How To Calculate Age in Days, Hours and Minutes in SQL Server Transact-SQL? On many Web sites, news ...