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.