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
2020-03-15, 814👍, 0💬
Popular Posts:
How Can Windows Applications Connect to Oracle Servers in Oracle? A Windows application can connect ...
What Are Date and Time Functions in MySQL? MySQL offers a number of functions for date and time valu...
Where to find answers to frequently asked questions on INSERT, UPDATE and DELETE Statements in MySQL...
How To List All User Names in a Database in SQL Server? If you want to see a list of all user names ...
Where to find Oracle database server tutorials? Here is a collection of tutorials, tips and FAQs for...