O Apex
Friday, September 4, 2015
How to get every first letter from a string ?
SELECT
REGEXP_REPLACE
(
'KUMAR SHIVAM MYTHASS'
,
'(^| )([^ ])([^ ])*'
,
'\2'
) FIRST_LETTERS
FROM
DUAL;
FIRST_LETTERS ------------- KSM
No comments:
Post a Comment
Newer Post
Older Post
Home
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment