Oracle E Business Suite
Pages
Home
Services
About Us
Sunday, April 16, 2017
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
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment