--DECOMPOSE

--Example 1
SELECT DECOMPOSE('é') AS D_TEST
FROM dual;

--Example 2

SELECT DECOMPOSE('Je suis américain') AS D_TEST
FROM dual;

http://www.databasestar.com/oracle-decompose

A few examples of the DECOMPOSE function.

Oracle DECOMPOSE Function

sql, Oracle

SQL