Query to Get Every First Letter From The String

Query to Get Every First Letter From The String , askhareesh blog for Oracle Apps

SELECT 'Oracle Applications',
       REGEXP_REPLACE ('Oracle Applications', '(^| )([^ ])([^ ])*', '\2')
          first_letters
  FROM DUAL;


Output : 

'OracleApplications'      FIRST_LETTERS
============           ==============
Oracle Applications                   OA


*/

No comments:

Post a Comment