DUMP

DUMP is a String function of Oracle. This function returns the string datatype code, length in bytes and some internal representation of the given string.

Syntax

Parameters

expression: string or an expression for the result.

return_format: it is optional. The return value format can be in one of the following values.

ValueExplanation
8octal notation
10decimal notation
16hexadecimal notation
17single characters
1008octal notation with the character set name
1010decimal notation with the character set name
1016hexadecimal notation with the character set name
1017single characters with the character set name

start_position: it is Optional. Starting position of the given expression.

Length: it is optional. Length of the given expression

Return

This function returns a VARCHAR2 value.

Example 1


Oracle String DUMP Function

Example 2


Oracle String DUMP Function
Next TopicOracle String




Latest Courses