TO_NUMBER is one of the vital Conversion functions of Oracle. It is used to convert a string to a number. The TO_NUMBER 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_NUMBER ( char, format_mask, nls_language ) Parameters: char: It is … Read more
TO_SINGLE_BYTE is one of the vital Conversion functions of Oracle. It is used to convert a character value with all of the multi-byte characters to single-byte characters. The TO_SINGLE_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_SINGLE_BYTE ( char … Read more
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