Monday
Nov012010
Quick tip...
Monday, November 1, 2010 at 9:15AM I'll get on posting more often now but here is a quick tip/code sample...
Sometimes you get customer/person info in the last, first format and you need first last...here is a quick reg expression to take care of that...
select REGEXP_REPLACE(
'last, first',
'(.*), (.*)', '\2 \1') name
from dual;
'last, first',
'(.*), (.*)', '\2 \1') name
from dual;
NAME
----------
first last
Reader Comments