oracle compose()函數

在oracle中，使用compose()函數可以返回一個unicode字符串。本教程，將為大家帶來compose()函數的語法及使用示例。

compose()函數語法

<span class="n">compose</span><span class="p">(</span> <span class="n">string</span> <span class="p">)</span> 

string：用于創建unicode字符串的輸入值。 它可以是char，varchar2，nchar，nvarchar2，clob或nclob。

返回值

返回一個字符串值。

以下是可以在compose()函數中的其他字符組合使用的unistring值的列表：

適用版本

compose()函數可用于以下版本的oracle ：

oracle 12c、 oracle 11g、 oracle 10g、 oracle 9i

示例

下面是oracle compose()函數的使用示例：

<span class="n">compose</span><span class="p">(</span><span class="s1">'o'</span> <span class="o">||</span> <span class="n">unistr</span><span class="p">(</span><span class="s1">'\0308'</span><span class="p">)</span> <span class="p">)</span> <span class="k">result</span><span class="p">:</span> <span class="err">?</span> <span class="n">compose</span><span class="p">(</span><span class="s1">'a'</span> <span class="o">||</span> <span class="n">unistr</span><span class="p">(</span><span class="s1">'\0302'</span><span class="p">)</span> <span class="p">)</span> <span class="k">result</span><span class="p">:</span> <span class="err">a</span> <span class="n">compose</span><span class="p">(</span><span class="s1">'e'</span> <span class="o">||</span> <span class="n">unistr</span><span class="p">(</span><span class="s1">'\0301'</span><span class="p">)</span> <span class="p">)</span> <span class="k">result</span><span class="p">:</span> <span class="err">é</span>