Oracle - PL/SQL - DECOMPOSE Function

In Oracle/PLSQL, the decompose function accepts a string and returns a Unicode string.

The syntax for the decompose function is:

decompose( string )

string is the string that will be decomposed.

Applies To:

  • Oracle 9i, Oracle 10g, Oracle 11g

For example:

decompose('Très bien')

would return 'Tre`s bien'

decompose('é')

would return 'e´'

decompose('olé')

would return 'ole´'