Oracle String/Char Function - Oracle/PLSQL COMPOSE Function






This Oracle tutorial explains how to use the Oracle/PLSQL COMPOSE function.

COMPOSE(x) converts x to a normalized unicode string in the same character set as x.

A listing of unistring values that can be combined with other characters in the compose function:

Unistring ValueResulting character
unistr('\0300')grave accent ( ` )
unistr('\0301')
unistr('\0302')circumflex ( ^ )
unistr('\0303')tilde ( ~ )
unistr('\0308')




Syntax

The syntax for the Oracle/PLSQL COMPOSE function is:

COMPOSE( string )

string is the input value used to create the Unicode string.

string can be a char, varchar2, nchar, nvarchar2, clob, or nclob.

Example


SQL> select compose('o' || unistr('\0308') ) from dual;

C
-


SQL>