Oracle function 1

Oracle functions

Sysdate:- returns current date and time.

Avg(n):- returns average ignoring null value.

Sum(n):- returnas sum values

Max (expr) :- returns maximum vaule of the expression

Min(expr): - returns minimum value of the expression

Count(*):- returns the number of the rows including the duplicate and the nulls.

Power(m,n):- returns the power of the value.

Round(n,m):-returns n rounded to n places.

Sqrt(n):returns the sqrt of the n.String function:-

Lower(char):-returns char with lower case.

Upper(char):-returns char with upper case.

Initcap(char):returns string with first letter with upper case.

Substr(char,m,n):- returns the substring beginning with position m upto n characters

Length(char):-reutrns the length of the string.

Ltrim(string,trim_string):- string1 is the string to trim the characters from the left-hand sidetrim_string is the string that will be removed from the left-hand side of string1. If this parameter is omitted, the ltrim function will remove all leading spaces from string1.

Rtrim(string,rtrim_string)string1 is the string to trim the characters from the right-hand side.trim_string is the string that will be removed from the right-hand side of string1. If this parameter is omitted, the rtrim function will remove all trailing spaces from string1.

Lpad(char1,n,char2):-returns char 1 left padded to length ‘n’ with sequence of characters in ‘char2’Rpad(char1.n.char2):returns char 1 right padded to length n with sequence of character in ‘char2’