TO_TIMESTAMP is one of the vital Conversion functions of Oracle. It is used to convert a string to a timestamp. The TO_TIMESTAMP function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i. Syntax: TO_TIMESTAMP ( char, format_mask, nls_language ) Parameters: char: It is used to … Read more

TO_TIMESTAMP_TZ is one of the vital Conversion functions of Oracle. It is used to convert a string to a timestamp with time zone. The TO_TIMESTAMP_TZ function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i. Syntax: TO_TIMESTAMP_TZ ( char, format_mask, nls_language ) Parameters: char: It … Read more

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

TRUNC (dates) is one of the vital Date/Time functions of Oracle. It is used to get a date truncated to a specific unit of measure. The TRUNC (dates) function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: TRUNC ( date, format … Read more

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

TRUNCATE TABLE To truncate or remove records of a table but not the structure, the Oracle TRUNCATE TABLE statement is used. It is much similar to the DELETE statement but the TRUNCATE TABLE statement cannot be rolled back, which is possible in the case of the DELETE statement. Also, this statement does not affect indexes, … Read more

TZ_OFFSET is one of the vital Date/Time functions of Oracle. It is used to get the time zone offset of a value. The TZ_OFFSET function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g and Oracle 9i. Syntax: TZ_OFFSET ( timezone ) Parameters: timezone: It is used to … Read more

UID is an advanced function that the Oracle database supports. It is used to get the id number for a user’s session. The UID function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: UID Example: SELECT UID INTO test_uid FROM dual;SELECT … Read more

USER is an advanced function that the Oracle database supports. It is used to get the user_id from the current Oracle session. The USER function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: USER Example: SELECT USER INTO test_user_id FROM dual;SELECT … Read more

VAR_POP is one of the vital Analytic functions of Oracle. It is used to get the population variance of a set of numbers. The VAR_POP function is supported in the various versions of the Oracle/PLSQL, including, Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i and Oracle 8i. Syntax: VAR_POP ( expression ) Parameters: expression: It … Read more