The DECOMPOSE Function in PLSQL is used for accepting a string and returning its Unicode string.
The DECOMPOSE Function is generally the opposite of the COMPOSE function.
The DECOMPOSE function is valid only for Unicode characters and it returns a Unicode string after decomposition in the same character set as the input.
The results of the inputs used can vary depending on the character set of the operating system used.
DECOMPOSE( string )
string – It is used to specify the string that needs to be decomposed.
The DECOMPOSE function returns a Unicode string.
Supported Versions of Oracle/PLSQL:
- Oracle 12c
- Oracle 11g
- Oracle 10g
- Oracle 9i
DECLARE Test_String2 varchar(5) := 'â'; Test_String varchar(20) := 'Gèèksforgèèks'; BEGIN dbms_output.put_line(DECOMPOSE(Test_String)); dbms_output.put_line(DECOMPOSE(Test_String2)); END;
- PLSQL | LN Function
- PLSQL | LOG Function
- PLSQL | LEAST Function
- PLSQL | TAN Function
- PLSQL | COS Function
- PLSQL | SIN Function
- PLSQL | EXP Function
- PLSQL | MOD Function
- PLSQL | ABS Function
- PLSQL | CHR Function
- PLSQL | LOWER Function
- PLSQL | INSTR2 Function
- PLSQL | REPLACE Function
- PLSQL | NCHR Function
- PLSQL | SUBSTR Function
If you like GeeksforGeeks and would like to contribute, you can also write an article using contribute.geeksforgeeks.org or mail your article to email@example.com. See your article appearing on the GeeksforGeeks main page and help other Geeks.
Please Improve this article if you find anything incorrect by clicking on the "Improve Article" button below.