Swaminathan K
asked on
Need help on regular expression
Hi Need to write change an regular expression to change the below text
Input string 'Jack and Jill'
and I need to change it to Jill and Jack.
Select regexp_replace('Jack and Jill','(\w).*(\w)','\2.*\1 ') from dual;
But it is not working . Any help is really appreciated.
Input string 'Jack and Jill'
and I need to change it to Jill and Jack.
Select regexp_replace('Jack and Jill','(\w).*(\w)','\2.*\1
But it is not working . Any help is really appreciated.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.