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, 1792🔥, 0💬
Popular Posts:
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To Start MySQL Server in MySQL? If you want to start the MySQL server, you can run the "mysqld" ...
What Happens If the Imported Table Already Exists in Oracle? If the import process tries to import a...
How To Set Up SQL*Plus Output Format in Oracle? If you want to practice SQL statements with SQL*Plus...
How To Replace Given Values with NULL using NULLIF() in SQL Server Transact-SQL? Sometime you want t...