Oracle PL/SQL/Char Functions/COMPOSE
compose("de" || unistr("\0300") )
<source lang="sql">
SQL> SQL> SQL> select compose("de" || unistr("\0300") ) from dual; dF 1 row selected. SQL>
</source>
COMPOSE(x):Converts x to a Unicode string in its fully normalized form in the same character set as x
<source lang="sql">
SQL> -- COMPOSE(x):Converts x to a Unicode string in its fully normalized form in the same character set as x. SQL> SQL> select compose("o" || unistr("\0308") ) from dual; C -
SQL> SQL> select compose("a" || unistr("\0302") ) from dual; C -
SQL> select compose("e" || unistr("\0301") ) from dual
2
SQL> SQL>
</source>