NEW_TIME is one of the vital Date/Time functions of Oracle. It is used to convert a date from one time zone to another. The NEW_TIME function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i. Syntax: NEW_TIME ( date, zone1, zone2 ) Parameters: date: It … Read more
NANVL is an advanced function that the Oracle database supports. It is used to substitute a value for a floating point number, when a Nan (Not a number) value is encountered. The NANVL function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, and Oracle 10g. Syntax: NANVL (value, replace_with) … Read more
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