The replace functions allows you to replace all occurences of one string with another. The syntax for the replace function is: replace ( string , search_string, change_to) string is the source string. search_string is the character or set of characters
Abs – Oracle SQL Function
ABS returns the absolute value of a numeric argument. It takes a numerics value, or any value that can be implicitly converted to a numeric value, as its argument and returns the absolute value as a numeric value. The return
Substr – Oracle SQL Function
The substr functions allows you to extract a substring from a string. The syntax for the substr function is: substr ( string , start_position , [ length ]) string is the source string. start_position is the position for extraction. The
Exp – Oracle SQL Function
EXP returns 2.71828183 raised to the exp power. Example: SELECT EXP(2) as squared from dual; SQUARED ———————- 7.38905609893065022…..
Nvl – Oracle SQL Function
The NVL function lets you substitutes a non-value when a null value is encountered. The syntax for the NVL function is: NVL ( string1, replace_with ) string1 is the string to test for a null value. replace_with is the value
Ln – Oracle SQL Function
LN returns the natural log of the argument. The argument can be a numeric value or any type that can be implicitly converted to a numeric value. The function returns a value that is the same type as the numeric
Avg – Oracle SQL Function
AVG returns the average value of a column. Syntax: AVG(column name) e.g. SELECT AVG(SALARY) FROM EMPLOYEE
Corr – Oracle SQL Function
CORR returns the coefficient of a pair of numbers. Syntax: CORR(expression1, expression2) Both expressions can NUMBER values or any value that can be converted to a NUMBER. e.g. SELECT id, CORR(list_price, min_price) as RESULTS FROM product_info GROUP BY supplier_id NOTE:
Count – Oracle SQL Function
COUNT returns the number of rows returned by the query where the expression is not NULL. Syntax: COUNT([DISTINCT] expression) If you pass the count function the (*) wildcard then it will return the count of all rows, including the rows
Covar_pop – Oracle SQL Function
COVAR_POP returns the population covariance of a pair of numbers. Syntax: COVAR_POP(expression1, expression2) Example: SELECT id, COVAR_POP(list_price,min_price) as RESULT FROM product_information GROUP BY id;