Learning Oracle SQL and PL/SQL
Wednesday, May 25, 2016
How to add first name first letter to last name name
By using regular expression replace it is possible to add first letter of name to the beginning of the last name.
SELECT
LOWER
(regexp_replace(
'Lucky, Edy E'
,
'(.+)(, )([A-Z])(.+)'
,
'\3\1'
,
1
,
1
))
FROM
DUAL;
Result : elucky
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment