Oracle与Sql Server函数对照

《Oracle与Sql Server函数对照》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、下面是Oracle支持的字符函数和它们的MicrosoftSQLServer等价函数：函数                                                                      Oracle                                          SQL　Server把字符转换为ASCII:                                                 ASCII                                           ASCII字串连接:   

2、                                                            CONCAT                                       (expression+expression)把ASCII转换为字符                                                   CHR                                              CHAR返回字符串中的开始字符（左起）                                 INST

3、R                                           CHARINDEX把字符转换为小写                                                     LOWER                                         LOWER把字符转换为大写                                                     UPPER                                           UPPER填充字符串的左边        

4、                                             LPAD                                             N/A清除开始的空白                                                        LTRIM                                          LTRIM清除尾部的空白                                                        RTRIM               

5、                           RTRIM字符串中的起始模式（pattern）                                  INSTR                                           PATINDEX多次重复字符串                                                        RPAD                                           REPLICATE字符串的语音表示                            

6、                         SOUNDEX                                     SOUNDEX重复空格的字串                                                        RPAD                                           SPACE从数字数据转换为字符数据                                          TO_CHAR                                     STR子串 

7、                                                                     SUBSTR                                       SUBSTRING替换字符                                                                 REPLACE