What is Compose Function in Oracle?

 Posted by Niladri.Biswas on 5/17/2013 | Category: Oracle Interview questions | Views: 1633 | Points: 40
Answer:

The Compose function of Oracle accepts a string and returns a Unicode string.It also accepts an expression that can be resolve to a string.

Syntax

Compose(string)

where "string" parameter can be a Char,Nchar,NClob,NCHAR, DUACLOB, VARCHAR2, or NVARCHAR2.

SQL> Select

2 Compose('A' || UniStr('\0300')) GraveAccent
3 ,Compose('A' || UniStr('\0301')) AcuteAccent
4 ,Compose('A' || UniStr('\0302')) CircumFlex
5 ,Compose('A' || UniStr('\0303')) Tilde
6 ,Compose('A' || UniStr('\0308')) Umlaut
7 From Dual;

G A C T U
- - - - -
À Á Â Ã Ä


Asked In: Many Interviews | Alert Moderator 

Comments or Responses

Login to post response