1、数学函数
2、部分数学函数使用
2.1 ABS
select abs(-5.6) as num1, abs(5.6) as num2 from dual;
2.2 CEIL/FLOOR/ ROUND
select ceil(5.6) as f_ceil, floor(5.6)as f_floor, round(5.6) as f_round from dual;
2.3 MOD
select mod(10, 3) as f_mod from dual;
2.4 POW/SQRT/ROOT
select pow(2, 3) as f_pow3, sqrt(25) as f_sqrt, root(64, 3) as f_root from dual;
2.5 EXP
select exp(1) as f_exp from dual;
3、字符串函数
4、部分字符串函数使用
4.1 concat
select concat(‘Hello’, ‘World’) as f_concat from dual;
4.2 TRIM/LTRIM/RTRIM
select f_message,
octet_length(f_message) as f_len1,
octet_length(trim(f_message)) as f_len2,
octet_length(ltrim(f_message)) as f_len3,
octet_length(rtrim(f_message)) as f_len4
from (select ’ Hello world ’ as f_message from dual) t;
4.3 INSTR
select instr(‘How are you?’, ‘o’, 1, 1) as f_instr1, instr(‘How are you?’, ‘o’, 1, 2) as f_instr2 from dual;
4.4 ASCII
select ascii(‘Hello’) as f_ascii1, ascii(‘world’) as f_ascii2, ascii(‘冀辉’) as f_ascii3 from dual;
select ascii(‘冀’) as f_ascii1, ascii(‘辉’) as f_ascii2, ascii(‘冀辉’) as f_ascii3 from dual;
4.5 REPLACE
select content, replace(content, ‘reading’, ‘writing’) as f_replace from (select ‘I like reading’ as content from dual) t;