Tag: Oracle SQL

Oracle/PLSQL REGEXP_COUNT function calculates the number of occurrences of the template in the string. This function, introduced in Oracle 11g, allows you to count the number of times a substring...

The Oracle/PLSQL POWER function elevates m to degree n. Oracle/PLSQL syntax of the POWER function POWER( m, n ) Parameters or argumentsm - is the base. n - is an indicator.The...

Oracle/PLSQL MOD function returns the residue from division m by n. Oracle/PLSQL syntax of the MOD function MOD( m, n ) Parameters and function argumentsMOD is calculated as: m - n *...

The Oracle/PLSQL MIN function returns the minimum value of the expression. Oracle/PLSQL syntax of MIN function SELECT MIN(aggregate_expression_id) FROM tabs [WHERE conds]OR syntax for MIN...

The Oracle/PLSQL MEDIAN function returns the expression median. Oracle/PLSQL syntax of MEDIAN function MEDIAN( expression_id ) [ OVER ( query partition clause ) ] Parameters and function...

The Oracle/PLSQL MAX function returns the maximum value of the expression. Oracle/PLSQL syntax of the MAX function SELECT MAX(aggregate_expression_id) FROM tabs [WHERE conds]OR syntax for...

The Oracle/PLSQL LOG function returns the logarithm n at the base m. Syntax of the Oracle/PLSQL LOG function LOG( m, n ) Parameters and argumentsm must be a positive number, except 0 or...

Oracle/PLSQL LEAST function returns the smallest value in the expression list. Oracle/PLSQL syntax of the LEAST function LEAST( expr1_id, expr2_id, ... expr_n_id ) Parameters and function...

Oracle/PLSQL GREATEST function returns the highest value in the list of expressions. Oracle/PLSQL syntax of the GREATEST function GREATEST( expr1_id, expr2_id, ... expr_n_id ) Parameters and...

The Oracle/PLSQL FLOOR function returns the largest integer value equal to or less than a number. Oracle/PLSQL syntax of the FLOOR function FLOOR( number_id ) Parameters and function...

The Oracle/PLSQL ACOS function returns the number arcosine. Oracle/PLSQL syntax of the ACOS function ACOS( number_id ) Parameters and function argumentsnumber_id - number to calculate...

Oracle/PLSQL EXP function returns e elevated to n-th degree where e = 2.71828183. Oracle/PLSQL syntax of the EXP function exp( number_id ) Parameters and function argumentsnumber_id -...

The Oracle/PLSQL COUNT function  returns the number of rows returned by the query. Oracle/PLSQL syntax of COUNT function SELECT COUNT(aggregate_expression_id) FROM tabs [WHERE conds]OR...

The Oracle/PLSQL CEIL function returns the smallest integer number that is greater than or equal to number. Oracle/PLSQL syntax of CEIL function CEIL( number_id ) Parameters and function...

The Oracle/PLSQL BITAND function returns an integer number representing the bitwise operation AND over the bits expr1 and expr2. Oracle/PLSQL syntax of the BITAND function bitand( expr1_id,...

The Oracle/PLSQL AVG function returns the average value of the expression. Oracle/PLSQL syntax of AVG function SELECT AVG(aggregate_expression_id) FROM tabs [WHERE conds]OR AVG function...