Gbase8s 数据库标量函数包括数学函数、字符串函数、日期时间函数。以下是对Gbase8s标量函数中字符串函数的介绍:
1、CONCAT 字符串拼接
示例:
select concat (‘abc’,‘def’) as new from dual;
结果:
2、TRIM 从字符串的开头或结尾移除指定字符
示例:
select octet_length(’ abc def ‘) as old,octet_length(trim(’ abc def ')) as new from dual;
结果:
3、SUBSTR 截取字符串
示例:
select substr(‘abcdefg’,2,3) as new from dual;
结果:
4、UPPER 将字符串的字母转成大写
示例:
select upper (‘abcdefg’) as new from dual;
结果:
5、LOWER 将字符串的字母转成小写
示例:
select lower (‘ABCDEFG’) as new from dual;
结果:
6、LENGTH 返回字符串的长度
示例:
select length (‘南大通用’) as new from dual;
结果:
7、REPLACE 替换字符串中的部分内容
示例:
select replace(‘abcdef’,‘a’,‘z’) as new from dual;
结果: