sql get initials from name code example

Example: how to get initials in sql

SELECT UPPER(FIRST_NAME) , LOWER(LAST_NAME) 
        , SUBSTR(FIRST_NAME , 1,1) || SUBSTR(LAST_NAME , 1,1)  AS INITIALS
FROM EMPLOYEES ;