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;
Covar_samp – Oracle SQL Function
COVAR_SAMP returns the sample covariance of a pair of numbers. Syntax: COVR_SAMP(expression1, expression2) Example: SELECT id, COVAR_SAMP(list_price,min_price) as RESULT FROM product_information GROUP BY id;
Cume_dist – Oracle SQL Function
CUME_DIST returns the relative position of a row within a group meeting certain criteria. You can specify one or more expressions to pass as arguments to the function. Syntax: CUME_DIST(expression1,… WITHIN GROUP (ORDER BY) Example: SELECT CUME_DIST(5000,103) WITHIN GROUP (ORDER
Dense_rank – Oracle SQL Function
DENSE_RANK returns a NUMBER representing the rank of a row within a group of rows. Syntax: DENSE_RANK(expression1,…) WITHIN GROUP (ORDER BY) Example: SELECT DENSE_RANK(5000,103) WITHIN GROUP (ORDER BY SALARY, MGR_ID) as RESULT FROM EMP; RESULT ———— 43