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
TANH is one of the vital Numeric/Math functions of Oracle. It is used to get the hyperbolic tangent of a number. The TANH function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: TANH ( number ) Parameters: number: It is used … Read more
TO_CHAR is one of the vital Conversion functions of Oracle. It is used to convert a number or date to a string. The TO_CHAR function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: TO_CHAR ( value, format_mask, nls_language ) Parameters: value: … Read more
TO_CLOB is one of the vital Conversion functions of Oracle. It is used to convert a LOB value to the database character set from the national character set. The TO_CLOB function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i. Syntax: TO_CLOB ( expression) Parameters: … Read more
TO_DATE is one of the vital Conversion functions of Oracle. It is used to convert a string to a date. The TO_DATE function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: TO_DATE ( string, format_mask, nls_language ) Parameters: string: It is … Read more
TO_DSINTERVAL is one of the vital Conversion functions of Oracle. It is used to convert a string to an INTERVAL DAY TO SECOND value. The TO_DSINTERVAL function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i. Syntax: TO_DSINTERVAL ( char, nls_language ) Parameters: char: It … Read more
The TO_LOB is one of the vital Conversion functions of Oracle. It is used to convert a LONG or LONG RAW values to LOB values. The TO_LOB function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: TO_LOB ( long_column ) Parameters: … Read more
TO_MULTI_BYTE is one of the vital Conversion functions of Oracle. It is used to convert a character value with all of the single-byte characters to multibyte characters. The TO_MULTI_BYTE function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: TO_MULTI_BYTE ( char … Read more
TO_NCLOB is one of the vital Conversion functions of Oracle. It is used to convert a LOB value to a NCLOB value. The TO_NCLOB function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i. Syntax: TO_NCLOB ( expression ) Parameters: expression: It is used to … Read more