NTH_VALUE is one of the vital Analytic functions of Oracle. It is used to get a specific value in an ordered set of values from an analytic window. The NTH_VALUE function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c and Oracle 11g Release 2. Syntax: NTH_VALUE (measure_column, n) [FROM FIRST | … Read more
STDDEV is one of the vital Analytic functions of Oracle. It is used to get the standard deviation of a set of numbers. The STDDEV function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. It can be used both as an analytic … 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
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