oracle通用函数(国外英文资料).doc

oracle通用函数(国外英文资料) Single Row Funciton features: ABS (n) : Function: the absolute value of n. Comment: the variable element allows for numeric constants, numeric column names, and text containing a valid numeric value A string or a character column name that contains a valid numeric value. Ii) CEIL (n) : Funciton: the smallest integer that is equal to or greater than n. Comment: the mathematical uplifting operation. Iii) FLOOR (n) : Function: the maximum integer that is equal to or less than n. Comment: the mathematical downtaking operation. Iv).mod (m, n) : Function: take the remainder of n (n = 0). Comment: MOD (m, 1) = 0 means that m is an integer. V).power (m, n) : Function: m to the n. Comment: the n requirement is an integer (otherwise the error will be returned). [n]) : Function: n 0, the m is rounded to the right of the decimal point; When n is less than 0, were going to put the m decimal The left-hand side of | n | (including the decimal part) is truncated and added | n | 0 (the first | n | + 1 is rounded from the | n |.) Comment: N 0, equal to 10 ^ | | n * m / 10 ^ | | n + 0.5]; N = 0 or n is omitted M is taking the whole thing. Vii). The SIGN (n) : Function: if n 0, the Function returns -1; If = 0, the function returns 0; If n 0, the function returns 1. Comment: the positive and negative of n. Viii). SQRT (n) : Function: take the square root of n. Comment: when n 0, the function returns NULL (ORACLE does not support imaginary Numbers). (c). Function: n 0, you intercept the n bits of the decimal point to the right. When n is less than 0, were going to put the m decimal The left-hand side of | n | (including the decimal part) is truncated and added | n | 0. Comment: N 0, equivalent to 10 ^ | | n * [m 10 ^ \ | | n]; N = 0 or n is omitted M is taking the whole thing. Character function I).ascii (s) : Function: the ASCII value or EBCDIC code value of the first character of s. Comment: the return value of a function depends on the character set used by t