--常用方法
select abs(-11) from dual; --abs取绝对值 11
select round(123.456,2) from dual; --四舍五入,保留两位小数 123.46
select ceil(12.34) from dual; -- 向上取整 13
select ceil(-12.34) from dual; -- 向上取整 -12
select floor(12.34) from dual; -- 向下取整 12
select mod(5,3) from dual; --取模 取余数 2
select sign(100) from dual; --取正负性 整数返回 1,负数返回-1,0返回0
select sign(0) from dual;
select sign(-100) from dual;
select sqrt(9) from dual; --求平方根 3
select power(3,2) from dual; --求乘方 9
select trunc(12.345,2) from dual; --截取 12.34
select to_char(12.345,'0000.0000') from dual; -- 格式化数值 0012.3450
select to_char(12.345,'9999.9999') from dual; -- 12.3450(前面有个空格)
select to_char(12.345,'fm9999.9999') from dual; --12.345 fm去前面空格
select to_char(123123,'99,999,999') from dual; -- 123,123
select to_char(12.345,'$9999.9999') from dual; -- $12.3450
select to_char(12.345,'L9999.9999') from dual; -- ¥12.3450
select to_char(12.345,'9999.9999c') from dual; -- 12.3450CNY
select abs(-11) from dual; --abs取绝对值 11
select round(123.456,2) from dual; --四舍五入,保留两位小数 123.46
select ceil(12.34) from dual; -- 向上取整 13
select ceil(-12.34) from dual; -- 向上取整 -12
select floor(12.34) from dual; -- 向下取整 12
select mod(5,3) from dual; --取模 取余数 2
select sign(100) from dual; --取正负性 整数返回 1,负数返回-1,0返回0
select sign(0) from dual;
select sign(-100) from dual;
select sqrt(9) from dual; --求平方根 3
select power(3,2) from dual; --求乘方 9
select trunc(12.345,2) from dual; --截取 12.34
select to_char(12.345,'0000.0000') from dual; -- 格式化数值 0012.3450
select to_char(12.345,'9999.9999') from dual; -- 12.3450(前面有个空格)
select to_char(12.345,'fm9999.9999') from dual; --12.345 fm去前面空格
select to_char(123123,'99,999,999') from dual; -- 123,123
select to_char(12.345,'$9999.9999') from dual; -- $12.3450
select to_char(12.345,'L9999.9999') from dual; -- ¥12.3450
select to_char(12.345,'9999.9999c') from dual; -- 12.3450CNY