Menu

Oracle Encoding And Decoding Functions

This section collects Oracle functions that decode values, inspect internal representations and sizes, or compute hashes. It includes DECODE(), DUMP(), VSIZE(), ORA_HASH(), and STANDARD_HASH().

  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 returns a VARCHAR2 describing a value’s internal data type code, byte length, and byte representation. Learn decimal, hex, character-set, start, and length options.

  3. ORA_HASH

    Learn Oracle ORA_HASH for bucketing and sampling, including its return range, default 32-bit value, seed, distribution limits, and examples.

  4. STANDARD_HASH

    Learn Oracle STANDARD_HASH syntax, the default SHA1 method, SHA256/384/512 and MD5 options, RAW digest sizes, and SQL examples.

  5. VSIZE

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