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
⇒ Use of Regular Expression in Oracle
2020-03-15, 1480👍, 0💬
Popular Posts:
How To Provide Default Values to Function Parameters in SQL Server Transact-SQL? If you add a parame...
What Is the Difference Between GETDATE() and GETUTCDATE() in SQL Server Transact-SQL? The difference...
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
How To Get Year, Month and Day Out of DATETIME Values in SQL Server Transact-SQL? You can use DATEPA...
How to set database to be READ_ONLY in SQL Server? Databases in SQL Server have two update options: ...