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, 3510🔥, 0💬
Popular Posts:
What is sqlservr.exe - Process - SQL Server (SQLEX?PRESS) in SQL Server? Process sqlservr.exe is the...
How To Count Rows with the COUNT(*) Function in SQL Server? If you want to count the number of rows,...
What are DDL (Data Definition Language) statements for tables in SQL Server? DDL (Data Definition La...
How To Enter Unicode Character String Literals in SQL Server Transact-SQL? Unicode characters are mu...
How to format a number of bytes in a human-readable unit using the FORMAT_BYTES() function? FORMAT_B...