Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Functions, 34 of 166
decompose::=
decompose
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 |
The following example decomposes the string "Châteaux" into its component codepoints:
SELECT DECOMPOSE ('Châteaux') FROM DUAL; DECOMPOSE --------- Cha^teaux
|
Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|