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.


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

Let’s go to the cafĂ© to get some coffee.

Compose – Oracle SQL Function
Tagged on: