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, 1849🔥, 0💬
Popular Posts:
How to download Microsoft SQL Server 2005 Express Edition in SQL Server? Microsoft SQL Server 2005 E...
How To Convert Binary Strings into Hexadecimal Character Strings in SQL Server? When a query returns...
What Happens to Your Transactions When ERROR 1205 Occurred in MySQL? If your transaction receives th...
How to set the current database in SQL Server? Once you are connected to the SQL Server, you should ...
What Happens to Your Transactions When ERROR 1213 Occurred in MySQL? If your transaction receives th...