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.

Compose – Oracle SQL Function
Tagged on: