Oracle / PLSQL: DECOMPOSE Function

This article is written about how to use the Oracle/PLSQL DECOMPOSE function with syntax and examples.

Description

The Oracle/PLSQL DECOMPOSE function accepts a string and returns a Unicode string.

Syntax

The syntax for the DECOMPOSE function in Oracle/PLSQL is:

DECOMPOSE( string )

Parameters or Arguments

string

The string that will be decomposed.

Returns

The DECOMPOSE function returns a Unicode string.

Applies To

The DECOMPOSE function can be used in the following versions of Oracle/PLSQL:

Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i

Example

Let’s look at some Oracle DECOMPOSE function examples and explore how to use the DECOMPOSE function in Oracle/PLSQL.

For example:

DECOMPOSE('Très bien')
Result: 'Tre`s bien'

DECOMPOSE('é')
Result: 'e´'

DECOMPOSE('olé')
Result: 'ole´'