--数学函数
select ABS(-15) from dual; --返回绝对值
select mod(10,3) from dual; --返回余数
select round(145.2584,-1) from dual; --四舍五入
select trunc(123.45,-1) from dual; -- 截取数字
--字符函数
select ascii('A') from dual; -- 返回首字母的ASCII 码
select chr(65) from dual; -- 和ascii 相反
select length('你好') from dual; --返回字符串的长度
select length('sfd') from dual;
select SUBSTR('ABCDEFG',3,4) from dual; --字符截取
select CONCAT('你好','!')||'中国' from dual;
select upper('ac') from dual;
select lower('AC') FROM DUAL;
select INITCAP('the soap') from dual; --首字母大写
select instr('oracle traning','ra',3) instring from dual; -- instr() 返回一个字符串在另一个字符串出现的位置
select replace('this is a test','tes','resul') from dual; --替换函数
select rpad('gao',6, '*') from dual; --右边字符串填充
select lpad('ni',5,'**') from dual; --左边字符串填充
select rtrim('nihao '),ltrim(' 欢迎您') from dual; --去左边,右边空格
select ABS(-15) from dual; --返回绝对值
select mod(10,3) from dual; --返回余数
select round(145.2584,-1) from dual; --四舍五入
select trunc(123.45,-1) from dual; -- 截取数字
--字符函数
select ascii('A') from dual; -- 返回首字母的ASCII 码
select chr(65) from dual; -- 和ascii 相反
select length('你好') from dual; --返回字符串的长度
select length('sfd') from dual;
select SUBSTR('ABCDEFG',3,4) from dual; --字符截取
select CONCAT('你好','!')||'中国' from dual;
select upper('ac') from dual;
select lower('AC') FROM DUAL;
select INITCAP('the soap') from dual; --首字母大写
select instr('oracle traning','ra',3) instring from dual; -- instr() 返回一个字符串在另一个字符串出现的位置
select replace('this is a test','tes','resul') from dual; --替换函数
select rpad('gao',6, '*') from dual; --右边字符串填充
select lpad('ni',5,'**') from dual; --左边字符串填充
select rtrim('nihao '),ltrim(' 欢迎您') from dual; --去左边,右边空格