Tag: Oracle

The Oracle/PLSQL ROUND function returns a number rounded to a certain number of digits after the decimal point. Syntax of Oracle/PLSQL function ROUND (for numbers) ROUND( number_id, [...

Oracle/PLSQL REMAINDER function returns the residue from division m by n. Oracle/PLSQL syntax of REMAINDER function REMAINDER( m, n ) Parameters and function argumentsm - is the numeric...

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...

There are official ratings and other analytical data that show DBMS popularity.Some ratings are based on the frequency of reference in search engine queries, ie, if people are more often looking...

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...