Compose – Oracle SQL Function

COMPOSE allows you to compose a UNICODE string by passing in one or more code points.

COMPOSE will add them all together and return the result.

Example:

SELECT COMPOSE(‘Let”s go to the cafe301 to get some tea.’)) as RESULT from DUAL;

RESULT
————–
Let’s go to the café to get some coffee.