DUMP
DUMP(expression, format, start, length)
Section titled “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
Section titled “Example”SELECT DUMP(name, 1016) "Name" FROM Employees WHERE ID = 1;Output
Section titled “Output”Name------------------------------------------Typ=1 Len=6: c,61,74,68,79,6eExplanation
Section titled “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.