Oracle9i SQL Reference Release 2 (9.2) Part Number A96540-01 |
|
Functions, 20 of 177
compose::=
COMPOSE
takes as its argument a string in any datatype, and returns a Unicode string in its fully normalized form 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" codepoint qualified by an umlaut codepoint will be returned as the o-umlaut codepoint.
See Also:
Oracle9i Database Concepts for information on Unicode character sets and character semantics |
The following example returns the o-umlaut codepoint:
SELECT COMPOSE ( 'o' || UNISTR('\0308') ) FROM DUAL; CO -- ö
|
Copyright © 1996, 2002 Oracle Corporation. All Rights Reserved. |
|