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
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment