![]() |
|||
|
![]() |
![]() |
|
FULL A - Z Oracle Function Library (formerly named "Morgan's Library")
![]() Term: DECOMPOSE
Definition: DECOMPOSE( STRING [CANONICAL | COMPATIBILITY]) Example: SQL> SELECT DECOMPOSE('ã') FROM DUAL; SQL> SELECT DECOMPOSE('ol' || COMPOSE('e' || UNISTR('\0301'))) Notes 1. The input string must be a character-based data type. It can be of CHAR, VARCHAR2, NCHAR, and NVARCHAR2 data types. CLOB and BLOB are supported since Oracle does implicit conversion to character till length of character supports. There are two modes available: CANONICAL and COMPATIBILITY. 2. CANONICAL is the default format. It decomposes the string in unicode format, which can be recovered using the COMPOSE function. 3. COMPATIBILITY decomposes the string in such a way that can not be recomposed using COMPOSE or any other way. Related Links: Related Code Snippets:
|
![]() |
Home | Search | Code Library | Sponsors | Privacy | Terms of Use | Contact Us | © 2003 - 2025 psoug.org |