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

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

NVL2 is an advanced function that the Oracle database supports. It is used to substitute a value, if a NULL value is encountered and to substitute another value, if a non-NULL value is encountered. The NVL2 function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i … Read more

NVL is an advanced function that the Oracle database supports. It is used to substitute a value, when a NULL value is encountered. The NVL function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: NVL (value, replace_with) Parameters: value: It is … Read more

NUMTOYMINTERVAL is one of the vital Conversion functions of Oracle. It is used to convert a number to an INTERVAL YEAR TO MONTH literal. The NUMTOYMINTERVAL function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: NUMTOYMINTERVAL ( number, expression ) Parameters: … Read more

NUMTODSINTERVAL is one of the vital Conversion functions of Oracle. It is used to convert a number to an INTERVAL DAY TO SECOND literal. The NUMTODSINTERVAL function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: NUMTODSINTERVAL ( number, expression ) Parameters: … Read more

NULLIF is an advanced function that the Oracle database supports. It is used to compare two expressions. The NULLIF function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i. Syntax: NULLIF( expr1, expr2 ) Parameters: expr1, expr2: They are used to specify the expressions to … Read more

NEXT_DAY is one of the vital Date/Time functions of Oracle. It is used to get the first weekday that is greater than the mentioned date. The NEXT_DAY function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i. Syntax: NEXT_DAY ( date, weekday ) Parameters: date: … Read more

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