SQL 函数参考手册.pdf

《SQL 函数参考手册.pdf》由会员上传分享，免费在线阅读，更多相关内容在行业资料-天天文库。

1、SQL函数参考手册Oracle、SQLServer、MySQL南無阿弥陀佛数据库系统自带函数..........................................................................................................................................................7字符函数.....................................................

2、.................................................................................................................7由字符获取ASCII码ASCII...............................................................................................................................7

3、格式化为ASCII字符串信息ASCIISTR(OracleOnly)..................................................................................7由字符获取UNICODE码................................................................................................................................

4、.8返回字符集CHARSET(MySQLOnly)..............................................................................................................8由ASCII码获取字符CHR/CHAR.......................................................................................................

5、...........8由UNICODE码获取字符NCHAR...................................................................................................................9字符串连接CONCAT

6、

7、/+.................................................................................................

8、................................9单词首字母大写INITCAP(OracleOnly)........................................................................................................10字符替换INSERT(MySQLOnly)........................................................................

9、...........................................10字符串搜索INSTR/CHARINDEX/LOCATE..............................................................................................11获取字符串左边开始指定个数的字符LEFT......................................................................

10、...........................12字符串长度LENGTH/LEN............................................................................................................................13加载文件LOAD_FILE（MySQLOnly）