常用Oracle的系统函数、过程与包.docVIP

* SQL常用函数： 数值函数： * ABS Purpose 返回绝对值 Returns the absolute value of n. Example SELECT ABS(-15) Absolute FROM DUAL; Absolute 15 * CEIL Purpose 取最小整数 Returns smallest integer greater than or equal to n. Example SELECT CEIL(15.7) Ceiling FROM DUAL; Ceiling 16 * MOD Syntax MOD(m,n) Purpose 取余 Returns remainder of m divided by n. Returns m if n is 0. Example SELECT MOD(11,4) Modulus FROM DUAL; Modulus 3 * ROUND Syntax ROUND(n[,m]) Purpose 取四舍五入信息 Returns n rounded to m places right of the decimal point; if m is omitted, to 0 places. m can b