Oracle/PLSQL: Compose Function

In Oracle/PLSQL, the compose function returns a Unicode string.

The syntax for the compose function is:

compose( string )

string is the input value used to create the Unicode string. It can be a char, varchar2, nchar, nvarchar2, clob, or nclob.

Below is a listing of unistring values that can be combined with other characters in the compose function.

Unistring Value Resulting character

unistr('\0300') grave accent ( ` )

unistr('\0301') acute accent ( ´ )

unistr('\0302') circumflex ( ^ )

unistr('\0303') tilde ( ~ )

unistr('\0308') umlaut ( ¨ )

Applies To:

Oracle 9i, Oracle 10g, Oracle 11g

For example:

compose('o' || unistr('\0308') ) would return ö

compose('a' || unistr('\0302') ) would return â

compose('e' || unistr('\0301') ) would return é