Quick Search:
CODE
Oracle PL/SQL Code Library
JOBS
Find Or Post Oracle Jobs
FORUM
Oracle Discussion & Chat
 The Oracle DECOMPOSE Function      [Return To Index] Jump to:  
  Looking for the original pages? (formerly called "Morgan's Library") You can find them here.

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      :      Code Library      :      Sponsors      :      Privacy      :      Terms of Use      :      Contact Us 241 users online    © 2009 psoug.org
PSOUG LOGIN
Username: 
Password: 
Forgot your password?