The instr function returns the location of a substring in a string. The syntax for the instr function is: instr ( string1 , string2 , [ start_position ], [ nth_appearance ]) string1 is the string to search. string2 is the
Median – Oracle SQL Function
MEDIAN returns the median value of the expression argument. Syntax: MEDIAN(expression) Example: SELECT MEDIAN(max_salary) as med FROM JOBS; MED —————- 10000
Floor – Oracle SQL Function
The floor functions allows you to round down any number to the nearest integer. For example: floor(6.02) would return 6 floor(7.789) would return 7 See Ceil to round numbers up to the nearest integer. See Round to round a number
Rank – Oracle SQL Function
RANK determines the rank of one or more of the expression exp within a result set. Syntax: RANK(expression…) WITHIN GROUP (ORDER BY expression) Example: SELECT RANK(10000) WITHIN GROUP (ORDER BY salary DESC) as RESULT FROM EMP; RESULT ——————- 16
Ceil – Oracle SQL Function
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