Tag: PL/SQL

Oracle/PLSQL CURRENT_DATE function returns the current date in the time zone of the current SQL session as set with the ALTER SESSION command. Oracle/PLSQL syntax of function...

The Oracle/PLSQL ADD_MONTHS function returns a date plus n months. Oracle/PLSQL syntax of ADD_MONTHS function ADD_MONTHS( date1_id, n_id ) Parameters and function argumentsdate1_id -...

Oracle Tutorials: Numric/Math FunctionsFunction DescriptionABS The Oracle/PLSQL function of ABS returns the absolute value of the number.ACOS The Oracle/PLSQL function ACOS...

The Oracle/PLSQL TRUNC function returns a number truncated to a certain number of digits after the decimal point. Oracle/PLSQL syntax of TRUNC function TRUNC( number_id, [ decimal_places_id ] )...

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

The Oracle/PLSQL SQRT function extracts the square root from the number. Syntax of the Oracle/PLSQL SQRT function SQRT( number_id ) Parameters and function argumentsnumber_id - is a...

The Oracle/PLSQL SINH function returns the hyperbolic sinus number. Oracle/PLSQL syntax of the SINH function SINH( number_id ) Parameters and function argumentsnumber_id - number.The...

The Oracle/PLSQL SIN function returns the sinus number. Oracle/PLSQL syntax of the SIN function SIN( number_id ) Parameters and function argumentsnumber_id - is a number, coal sinus in...

The Oracle/PLSQL SIGN function returns a value that defines a number sign. The Oracle/PLSQL syntax of the SIGN function SIGN( number_id ) Parameters and function argumentsa number_id -...

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