The ceil functions allows you to round up any number to the next integer. For example: ceil(6.02) would return 7 ceil(7.59) would return 8 See Round to round numbers to a particular decimal place See Floor to round a number
Stddev – Oracle SQL Function
STDDEV returns the sample standard deviation of the expression. STDDEV will return zero when it has only one row of input data. Syntax: STDDEV(expression) Example: SELECT STDDEV(COMMISSION_PCT) FROM EMP; STDDEV(COMMISSION_PCT) ——————————————– .0857432345
Round – Oracle SQL Function
The round functions allows you to round up any number to a certain number of decimal places. For example: round(6.02,1) would return 6.0 round(6.789,2) would return 6.79 See Ceil to round numbers up to the nearest integer. See Floor to
Variance – Oracle SQL Function
VARIANCE returns the variance of the values in expression. Syntax: VARIANCE(expression) Example: SELECT VARIANCE (COMMISSION_PCT) FROM EMP; VARIANCE(COMMISSION_PCT) ———————————————– .00726303
Replace – Oracle SQL Function
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