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