Oracle regular expressions query [message #671350] |
Thu, 23 August 2018 11:15 |
jackman1
Messages: 8 Registered: August 2010
|
Junior Member |
|
|
Hi experts,
I am not able to understand the result of the following query:
select regexp_replace('bb','a*','x') from dual;
Result:
xbxbx
Why is the regexp_replace function replacing the start and end of the string with 'x' and also inserting an 'x' in between 'b's?
I tried to search internet for articles related to boundary values etc. but could not find an explanation to what is happening here.
Any explanation/pointers or link related to the above will really help.
Thanks in advance
[EDITED by LF: applied [code] tags]
[Updated on: Fri, 24 August 2018 15:29] by Moderator Report message to a moderator
|
|
|
|
|