Oracle PL/SQL: COMPOSE - COMPOSE takes as its argument a string (or an expression that resolves to a string) in any datatype,

Quick Search:

Oracle PL/SQL: COMPOSE

Jump to:

Category: >> Oracle PL/SQL >> COMPOSE

<< last

next >>

Snippet Name: COMPOSE

Description: COMPOSE takes as its argument a string (or an expression that resolves to a string) in any datatype, and returns a Unicode string in its fully normalized form in the same character set as the input.

Also see:
» Add PSOUG Search to SQL Developer
» Converting Rows to Columns
» UNISTR
» TRANSLATE
» TO_YMINTERVAL
» TO_TIMESTAMP_TZ
» TO_TIMESTAMP
» TO_SINGLE_BYTE
» TO_NUMBER
» TO_NCLOB
» TO_NCHAR
» TO_MULTI_BYTE
» TO_LOB
» TO_DSINTERVAL
» TO_DATE
» TO_CLOB
» TO_CHAR
» TO_BINARY_FLOAT
» TO_BINARY_DOUBLE
» TIMESTAMP_TO_SCN
» SCN_TO_TIMESTAMP
» ROWIDTONCHAR
» ROWIDTOCHAR
» REFTOHEX
» RAWTONHEX
» RAWTOHEX
» NUMTOYMINTERVAL
» NUMTODSINTERVAL
» HEXTORAW
» DECOMPOSE

Comment: (none)

Language: PL/SQL
Highlight Mode: PLSQL
Last Modified: March 05th, 2009

COMPOSE(<string_or_column>)
 
-- This example returns the o-umlaut code point:
 
SELECT COMPOSE ( 'o' || UNISTR('\0308') ) FROM DUAL; 
 
CO 
-- 
Ã¶