Oracle9i SQL Reference Release 1 (9.0.1) Part Number A90125-01 |
|
Functions, 20 of 166
compose::=
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 |
SELECT COMPOSE ( 'o' || UNISTR('\0308') ) FROM DUAL; CO -- ö
|
![]() Copyright © 1996-2001, Oracle Corporation. All Rights Reserved. |
|