COMPOSE function in Oracle

COMPOSE is another vital string/char functions of Oracle. It is used to return the UNICODE String for the desired string. The COMPOSE function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i.

Syntax:

COMPOSE( string )


Parameters:
string: It is used to specify the string, for which the UNICODE string needs to be retrieved.

Example 1:

COMPOSE( I || unistr( '\0301' )

Output:

Í


Explanation:
The (\0301) is a UNICODE String of (´) and so is the result.

Example 2:

COMPOSE( I || unistr( '\0300' )

Output:

Ì


Explanation:
The (\0300) is a UNICODE String of (`) and so is the result.