Collections:
Use of Regular Expression in Oracle
How To Use Regular Expression in Pattern Match Conditions in Oracle?
✍: FYIcenter.com
If you have a pattern that is too complex for LIKE to handle, you can use the regular expression pattern patch function: REGEXP_LIKE().
The following script provides you some good examples:
SELECT CASE WHEN REGEXP_LIKE ('FYICenter.com', '.*fyi.*', 'i') THEN 'TRUE' ELSE 'FALSE' END FROM DUAL; TRUE SELECT CASE WHEN REGEXP_LIKE ('FYICenter.com', '.*com$', 'i') THEN 'TRUE' ELSE 'FALSE' END FROM DUAL; TRUE SELECT CASE WHEN REGEXP_LIKE ('FYICenter.com', '^F.*','i') THEN 'TRUE' ELSE 'FALSE' END FROM DUAL; TRUE
⇒ Understanding SQL DDL Statements for Oracle
⇐ Use LIKE Conditions in Oracle
2020-03-15, 2107🔥, 0💬
Popular Posts:
What is test testing area for? The testing area is provided to allow visitors to post testing commen...
How to execute statements in loops in SQL Server Transact-SQL? How to use WHILE ... loops? You can u...
How To Convert Numeric Values to Character Strings in MySQL? You can convert numeric values to chara...
How To Install PHP on Windows in MySQL? The best way to download and install PHP on Windows systems ...
Where Is the Export Dump File Located in Oracle? If you are not specifying the dump directory and fi...