Collections:
Use LIKE Conditions in Oracle
How To Use LIKE Conditions in Oracle?
✍: FYIcenter.com
LIKE condition is also called pattern patch. There 3 main rules on using LIKE condition:
The following script provides you some good pattern matching examples:
SELECT CASE WHEN 'FYICenter.com' LIKE '%Center%' THEN 'TRUE' ELSE 'FALSE' END FROM DUAL; TRUE SELECT CASE WHEN 'FYICenter.com' LIKE '%CENTER%' THEN 'TRUE' ELSE 'FALSE' END FROM DUAL; -- Case sensitive by default FALSE SELECT CASE WHEN 'FYICenter.com' LIKE '%Center_com' THEN 'TRUE' ELSE 'FALSE' END FROM DUAL; TRUE SELECT CASE WHEN '100% correct' LIKE '100\% %' ESCAPE '\' THEN 'TRUE' ELSE 'FALSE' END FROM DUAL; TRUE
2020-03-15, 791👍, 0💬
Popular Posts:
What Are Logical/Boolean Operations in SQL Server Transact-SQL? Logical (Boolean) operations are per...
How To Format DATETIME Values to Strings with the CONVERT() Function in SQL Server Transact-SQL? SQL...
Where to find answers to frequently asked questions on Conditional Statements and Loops in SQL Serve...
What are single-byte character string data types supported in SQL Server Transact-SQL? Single-byte c...
What is dba.FYIcenter.com Website about? dba.FYIcenter.com is a Website for DBAs (database administr...