DUMP

Oracle

DUMP(expression, format, start, length)

• expression: The value to describe.
• format: Optional notation for the returned bytes: 8 octal, 10 decimal, 16 hexadecimal, 17 characters. Add 1000 to append the character set name.
• start: Optional start position within the internal representation.
• length: Optional number of bytes to return.

Example

SELECT DUMP(name, 1016) "Name" FROM Employees WHERE ID = 1;

Output

Name
------------------------------------------
Typ=1 Len=6: c,61,74,68,79,6e

Explanation

The DUMP function returns a varchar2 value that includes the datatype code, length in bytes, and internal representation of the expression. In this case, an hex-dump (1016) of the name of an employee with ID 1 is obtained.