MONTHS_BETWEEN is one of the vital Date/Time functions of Oracle. It is used to get the number of months between two mentioned dates. The MONTHS_BETWEEN function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: MONTHS_BETWEEN ( date1, date2 ) Parameters: date1: … Read more

MOD is one of the vital Numeric/Math functions of Oracle. It is used to get the remainder of x divided by y. The MOD function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: MOD ( x, y ) Parameters: x, y: … Read more

MIN is one of the vital Numeric/Math functions of Oracle. It is used to get the minimum of an expression. The MIN function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax 1: To calculate simple MIN. SELECT MIN (aggregate_expression) FROM tables … Read more

MEDIAN is one of the vital Numeric/Math functions of Oracle. It is used to get the MEDIAN value of an expression. The MEDIAN function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: MEDIAN( expression ) Parameters: expression: It is used to … Read more

MAX is one of the vital Numeric/Math functions of Oracle. It is used to get the maximum of an expression. The MAX function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax 1: To calculate simple MAX. SELECT MAX (aggregate_expression) FROM tables … Read more

LOCALTIMESTAMP is one of the vital Date/Time functions of Oracle. It is used to get the current date and time in the time zone of the current SQL session. The LOCALTIMESTAMP function is similar as the CURRENT_TIMESTAMP function with the only difference that it returns a TIMESTAMP value instead of a TIMESTAMP WITH TIME ZONE … Read more

As the name itself suggests, these tables are distinct within modules. The Oracle provided the facility to define and scope the Local Temporary Tables to the session in which it is created. Syntax: To declare a LOCAL TEMPORARY TABLE with a single column. DECLARE LOCAL TEMPORARY TABLE table_name ( column_name data_type [ NULL | NOT … Read more

LNNVL is an advanced function that the Oracle database supports. It is used to evaluate a condition when one of the operands may contain a NULL value. The LNNVL function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, and Oracle 10g. Syntax: LNNVL (condition) Example: Students Table: ID CURRENT_MARKS … Read more

LN is one of the vital Numeric/Math functions of Oracle. It is used to get the natural logarithm of a number. The LN function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: LN( number ) Parameters: number: It is used to … Read more

LISTAGG is one of the vital Analytic functions of Oracle. It is used to concatenates values of a column for each GROUP. The LISTAGG function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c and Oracle 11g Release 2. Syntax: LISTAGG (measure_column, ‘delimiter’) WITHIN GROUP (order_by_clause) [OVER (query_partition_clause)] Parameters: measure_column: It is … Read more