DECOMPOSE

Syntax

decompose::=

Text description of decompose

Purpose

DECOMPOSE takes as its argument a string in any datatype, and returns a unicode string after canonical decomposition in the same character set as the input. string can be any of the datatypes CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB. For example, an o-umlaut codepoint will be returned as the "o" codepoint followed by an umlaut codepoint.

See Also: Oracle9i Database Concepts for information on unicode character sets and character semantics

Example

The following example decomposes the string "Châteaux" into its component codepoints:

SELECT DECOMPOSE ('Châteaux') FROM DUAL; 

DECOMPOSE
---------
Cha^teaux