Collections:
Use IN Conditions in Oracle
How To Use IN Conditions in Oracle?
✍: FYIcenter.com
An IN condition is single value again a list of values. It returns TRUE, if the specified value is in the list. Otherwise, it returns FALSE.
Some examples are given in the script below:
SELECT CASE WHEN 3 IN (1,2,3,5) THEN 'TRUE' ELSE 'FALSE' END FROM DUAL; TRUE SELECT CASE WHEN 3 NOT IN (1,2,3,5) THEN 'TRUE' ELSE 'FALSE' END FROM DUAL; FALSE SELECT CASE WHEN 'Y' IN ('F','Y','I') THEN 'TRUE' ELSE 'FALSE' END FROM DUAL; TRUE
⇒ Use LIKE Conditions in Oracle
⇐ Date and Time Differences in Oracle
2020-03-15, 1560🔥, 0💬
Popular Posts:
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
What Is Program Global Area (PGA) in Oracle? A Program Global Area (PGA) is a memory buffer that is ...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How To Start Instance with a Minimal Initialization Parameter File in Oracle? The sample initializat...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...