Learning Oracle SQL and PL/SQL
Thursday, May 26, 2016
How to find a word with different endings in the string
SELECT
REGEXP_SUBSTR(
'I have earned 100 dollars today '
,
'earn((ing)|(ed))'
)
FROM
dual;
result
: earned
If you change the string
SELECT
REGEXP_SUBSTR(
'I have been earning 100 dollars today '
,
'earn((ing)|(ed))'
)
FROM
dual;
result
: earning
No comments:
Post a Comment
‹
›
Home
View web version
No comments:
Post a Comment