INSTR4 is one of the vital string/char functions of Oracle. It is used to get the location of a substring, where a substring is a part of a string. It works same as INSTR and the INSTR2 function with the only difference that it uses UCS4 code points. The INSTR4 function is supported in the … Read more
LENGTH2 is one of the vital string/char functions of Oracle. It is used to get the length of a string, same as the LENGTH function with the only difference that it uses the UCS2 code points. The LENGTH2 function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, … Read more
LENGTH is one of the vital string/char functions of Oracle. It is used to get the length of a string. The LENGTH function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: LENGTH ( string ) Parameters: string: It is used to … Read more
LEAST is one of the vital Numeric/Math functions of Oracle. It is used to get the least value from a list of expressions. The LEAST function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: LEAST( expr_1, expr_2, … expr_n ) Parameters: … Read more
LAST_DAY is one of the vital Date/Time functions of Oracle. It is used to get the last day of the month. The LAST_DAY function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: LAST_DAY ( date ) Parameters: date: It is used … Read more
LOG is one of the vital Numeric/Math functions of Oracle. It is used to get the logarithm of x base y. The LOG function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: LOG( y, x ) Parameters: y: It must be … Read more
SESSIONTIMEZONE is one of the vital Date/Time functions of Oracle. It is used to get the current session’s time zone. The result generated is either as a time zone offset or a time zone region name. The SESSIONTIMEZONE function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g … Read more
SQRT is one of the vital Numeric/Math functions of Oracle. It is used to get the square root of a number. The SQRT function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: SQRT ( number ) Parameters: number: It is used … Read more
The SYS_CONTEXT is an advanced function that the Oracle database supports. It is used to get information about the Oracle environment. The SYS_CONTEXT function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: SYS_CONTEXT( namespace, parameter, length ) Parameters: namespace: It is … Read more
SYSDATE is one of the vital Date/Time functions of Oracle. It is used to get the current system date and time on the local database. The result generated is either as a time zone offset or a time zone region name. The SYSDATE function is supported in the various versions of the Oracle/PLSQL, including, Oracle … Read more