What is Decompose function in Oracle?

 Posted by Niladri.Biswas on 5/17/2013 | Category: Oracle Interview questions | Views: 2062 | Points: 40
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 

Comments or Responses

Login to post response