Quick Search:
 
 The Oracle DECOMPOSE Function      [Return To Index] Jump to:  

Term: DECOMPOSE

Definition:
The Oracle DECOMPOSE function is used to get the Unicode format of the input string. It is the reverse of the COMPOSE function in SQL.

Example Syntax:

DECOMPOSE( STRING [CANONICAL | COMPATIBILITY])


Example:

SQL> SELECT DECOMPOSE('ã') FROM DUAL;

DECO
----
a~


SQL> SELECT DECOMPOSE('ol' || COMPOSE('e' || UNISTR('\0301'))) 
2 FROM DUAL;

DECO
----
ole´


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:
  • DECOMPOSE - DECOMPOSE is valid only for Unicode characters. DECOMPOSE takes as its argument a stri...
 
   Home |    Search |    Code Library |    Sponsors |    Privacy |    Terms of Use |    Contact Us © 2003 - 2024 psoug.org