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

SYSTIMESTAMP is one of the vital Date/Time functions of Oracle. It is used to get the current system timestamp on the local database. The SYSTIMESTAMP function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i. Syntax: SYSTIMESTAMP Example: Select SYSTIMESTAMP INTO var from dual;Select SYSTIMESTAMP … Read more

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