"Oracle/PLSQL中的compose函数用于返回一个Unicode字符串。该函数接受如char、varchar2、nchar等类型作为输入，结合特定的Unicode值（如' 300'对应重音符）来构造Unicode字符串。例如，compose('o'||unistr(' 308'))将返回'ö'。此功能适用于Oracle11g、Oracle10g和Oracle9i。"
In Oracle/PLSQL, the compose function returns a Unicode string.
Syntax
The syntax for the compose function is:
compose( string )
string is the input value used to create the Unicode string. It can be a char, varchar2, nchar, nvarchar2, clob, or nclob.
Note
Below is a listing of unistring values that can be combined with other characters in the compose function.
| Unistring Value | Resulting character |
| unistr('\0300') | grave accent ( ` ) |
| unistr('\0301') | acute accent ( ´ ) |
| unistr('\0302') | circumflex ( ^ ) |
| unistr('\0303') | tilde ( ~ ) |
| unistr('\0308') | umlaut ( ¨ ) |
Applies To
- Oracle 11g, Oracle 10g, Oracle 9i
For Example
| compose('o' || unistr('\0308') ) | would return ö |
| compose('a' || unistr('\0302') ) | would return â |
| compose('e' || unistr('\0301') ) | would return é |
扫一扫
301
被折叠的 条评论
为什么被折叠?
到【灌水乐园】发言
