Oracle Common functions

1. Numerical functions

　　Round (N[,m])

　　　Rounded, M is 0 directly rounded n,m>0 take the decimal point after the M bit, m<0 take the decimal point before the |m| bit

　Ceil (N)

Take a minimum integer value greater than n

　　Floor (N)

Take the maximum integer value less than n

　　ABS (N)

Take the absolute value of n

　　MoD (n,m)

The remainder of the n/m is taken, if n or M is null the result is NULL

　　Power (N,M)

Takes the power of N, that is, n^m, if n or M is null, the result is null

　　SQRT (n)

Take the square root of n

Trigonometric functions: Sin (n), ASIN (n), cos (n), ACOs (n), Tan (n), Atan (n), where n is radians

2. Character functions

　Upper (str)

Take the uppercase of STR

　　Lower (str)

Take the lowercase of str

　Initcap (str)

Capitalize first letter

　　SUBSTR (Str[,n[,m])

Start with the nth letter of STR and the string with a length of M (when n is negative, start at the end of the string |n| position)

Length (str)

String length (including spaces) for Str

Concat (STR1,STR2)

with | | Same, connection for string

Trim (CChar from PSTR)

Remove the CChar (single-character) from the pstr and remove the pchar and trailing spaces if trim (pstr)

LTrim (Pstr,cchar)

Removal of CChar from the left of the PSTR (continuous)

RTrim (Pstr,cchar)

Remove CChar from the right of the Pchar (continuous)

Replace (STR,S_STR[,R_STR])

From STR, replace S_STR with R_STR, or null if R_STR is not filled

3. Date function

4. Conversion function

Oracle Common functions