COMPOSE
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 Value | Resulting character |
|---|---|
| unistr('\0300') | grave accent ( ` ) |
| unistr('\0301') | acute accent ( ´ ) |
| unistr('\0302') | circumflex ( ^ ) |
| unistr('\0303') | tilde ( ~ ) |
| unistr('\0308') | umlaut ( ¨ ) |
SQL> select compose('o' || unistr('\0308') ) from dual;
C
-
SQL>