Oracle DECOMPOSE Function

Oracle DECOMPOSE FunctionOracle 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´’


Tagged , , , , , , , , , , , . Bookmark the permalink.