Tag: PLSQL

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

The Oracle/PLSQL ABS function returns the absolute value of a number. Oracle/PLSQL syntax of the ABS function ABS( number_id ) Parameters and function argumentsnumber_id - for...

Symbolic Oracle functionsFunction DescriptionASCII The Oracle/PLSQL ASCII function returns the numeric representation of the leftmost character of the string.ASCIISTR The...

The Oracle/PLSQL VSIZE function returns the length in bytes for the internal representation of the expression. Syntax of the Oracle/PLSQL VSIZE function VSIZE( expression_id ) Parameters and...

The Oracle/PLSQL UPPER function converts all characters of a string into upper case. If there are characters in a string that are not letters, they do not affect this function. Syntax of the...

The Oracle / PLSQL TRIM function removes all specified characters from the beginning or end of a string. Function Oracle / PLSQL TRIM syntax TRIM( [ [ LEADING_id | TRAILING_id | BOTH_id ]...

The Oracle/PLSQL TRANSLATE function replaces the sequence of characters in a string with another character set. However, it replaces one character at a time.For example, it replaces the first...