Oracle Encoding And Decoding Functions

Encoding and decoding functions allow you to exainspectmine and decode data in the database. This page lists Oracle encoding and decoding functions.

  1. DECODE

    Oracle DECODE() is a built-in function that decodes a given parameter based on one or more given mapping relationships and returns the decoded value.

  2. DUMP

    Oracle DUMP() is a built-in function that returns a VARCHAR2 value containing the data type code, byte length, and internal representation of the expr.

  3. ORA_HASH

    Oracle ORA_HASH() is a built-in function that computes the hash value of a given expression.

  4. STANDARD_HASH

    Oracle STANDARD_HASH() is a built-in function that computes the hash value for a given expression using one of the multiple hash algorithms defined and standardized by the National Institute of Standards and Technology (NIST) in the United States.

  5. VSIZE

    Oracle VSIZE() is a built-in function that returns the number of bytes in the internal representation of the given expression.