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, 1639🔥, 0💬
Popular Posts:
How to change the data type of an existing column with "ALTER TABLE" statements in SQL Server? Somet...
What Is a Dynamic Performance View in Oracle? Oracle contains a set of underlying views that are mai...
Where to find SQL Server database server tutorials? Here is a collection of tutorials, tips and FAQs...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...
How To Query Tables and Loop through the Returning Rows in MySQL? The best way to query tables and l...