摘要: 函数包括:单行函数,多行函数(分组函数)数值函数:--绝对值select abs(-12.3) from dual;--向上取值select ceil(5.3) from dual;--向下取值select floor(5.3 )from dual;--四舍五入select round(123.4124,2)from dual;-- 截取小数点之后select trunc(4252.04524,2) from dual;--次方select power(2,3) from dual;--取余数select mod(12.11,4) from dual;--开方select sqrt(9) fr 阅读全文
posted @ 2013-12-28 00:15 狐狸不会飞 阅读(426) 评论(0) 推荐(0) 编辑