Oracle DECOMPOSE Function

Oracle DECOMPOSE Function is be used to convert a string to a UNICODE string. Syntax and examples of SQL DECOMPOSE Function are listed below.

Oracle DECOMPOSE Function Syntax

SELECT DECOMPOSE (string_1)
 FROM table_name;

In the above syntax the “string_1” is the string to be decomposed

Oracle DECOMPOSE Function – Use in SQL SELECT Statement Examples

Oracle/DECOMPOSE Function is used with the SQL SELECT Statement.

For example, the SQL query below returns a UNICODE string of the string passed.

SELECT DECOMPOSE('Tèch Honèy')
FROM dual;

The above SQL query returns ‘Tèch Honèy’.

Oracle DECOMPOSE Function – Use with Single Word Example

The below SQL query returns the UNICODE String of the string passed.

SELECT DECOMPOSE('olé')
FROM dual;

The above SQL query returns ‘ole´’