Answer: This function of Oracle returns a Unicode string.It is the exact opposite of Compose function.
Syntax
Decompose(string)
where "string" parameter can be a Char,Nchar,NClob,NCHAR, DUACLOB, VARCHAR2, or NVARCHAR2.
SQL> Select
2 DeCompose(Compose('A' || UniStr('\0300'))) Example
3 From Dual;
EX
--
A`
Asked In: Many Interviews |
Alert Moderator