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
Posted by Shivam at Friday, September 04, 2015 No comments:
Email ThisBlogThis!Share to XShare to FacebookShare to Pinterest
Labels: SQL
Newer Posts Older Posts Home
Subscribe to: Posts (Atom)

Collection

  • ►  2024 (1)
    • ►  May (1)
  • ►  2023 (1)
    • ►  Feb (1)
  • ►  2022 (3)
    • ►  Sep (1)
    • ►  Aug (2)
  • ►  2021 (1)
    • ►  Mar (1)
  • ►  2018 (3)
    • ►  Jul (1)
    • ►  Mar (1)
    • ►  Feb (1)
  • ►  2017 (5)
    • ►  Dec (1)
    • ►  Nov (2)
    • ►  May (2)
  • ►  2016 (8)
    • ►  Jul (5)
    • ►  Jun (2)
    • ►  Apr (1)
  • ▼  2015 (9)
    • ▼  Sep (1)
      • How to get every first letter from a string ?
    • ►  Aug (1)
    • ►  Jul (6)
    • ►  Jun (1)

About Me

Shivam
View my complete profile

Quote

It is better to know some of the questions than all of the answers. –James Thurber
Picture Window theme. Powered by Blogger.