DUMP

17 Mar 2025 | 1 min read

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.

Value	Explanation
8	octal notation
10	decimal notation
16	hexadecimal notation
17	single characters
1008	octal notation with the character set name
1010	decimal notation with the character set name
1016	hexadecimal notation with the character set name
1017	single 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

Example 2

Next TopicOracle String

← prev next →

LENGTHC()
Oracle Function LENGTHC is a String function of Oracle. This function returns the size using Unicode complete characters from the given string. Syntax LENGTHC( string1 ) Parameters string1: string for getting length. Return This function returns a numeric value. Example 1 Select lengthc('oracle') from dual; Example 2 Select lengthc('javatpoint') from dual; TopicOracle String ...
1 min read
SOUNDEX()
Oracle Function The is a String function of Oracle. This function returns a Soundex string which sounds almost same and have identical soundex strings. Syntax SOUNDEX(string1) Parameters String1 : string from getting soundex, which sounds exactly same Return It returns a string value. Example 1 SELECT SOUNDEX('javatpoint') FROM dual; Example 2 SELECT SOUNDEX ('oracle')...
1 min read
RTRIM()
Oracle Function RTRIM(str) is a String function of Oracle. This function returns the string by removing given characters from the right side. Syntax RTRIM( string1 [, trim_string] ) Parameters string1 : string to be trimmed from right-hand side. trim_string : it is optional. It is the string to be removed from...
1 min read
RPAD()
Oracle Function RPAD is a String function of Oracle. This function returns the right-padded to the given length. Syntax RPAD( string1, padded_length [, pad_string] ) Parameters string1: string to be padded from the right. padded_length : length to be padded from the right. pad_string: it is optional. It is the string that...
1 min read
SUBSTR()
Oracle Funcion SUBSTR is a String function of Oracle. This function is used to extract the sub string from the given string. Syntax SUBSTR( string, start_position [, length ] ) Parameters String : string for getting sub string. start_position : strating position of the string. Length : it is optional. Length of...
1 min read
ASCIISTR
is a String function of Oracle. This function returns the numeric value of given character. It converts given string to character and then to ASCII string. Syntax (string) Parameters string: It is a string in any character set. Returns This function reruns a string value. Example 1 SELECT ('J Ä V Ä')...
1 min read
Oracle VSIZE() Function
VSIZE is a String function of Oracle. The length function provides a byte count for provided expressions. Syntax VSIZE( expression ) Parameters Expression: It represents the input value against which memory size in bytes is tested. The input can be a string, a numeric value, or even a NULL...
3 min read
REGEXP_INSTR()
Oracle Function REGEXP_INSTR is a String function of Oracle. It is an extension of INSTR function. This function is used for pattern matching in a string. Syntax REGEXP_INSTR( string, pattern [, start_position [, nth_appearance [, return_option [, match_parameter [, sub_expression ] ] ] ] ] ) Parameters String: string...
4 min read
LENGTHB()
Oracle Function LENGTHB is a String function of Oracle. This function returns the size using bytes instead of characters from the given string. Syntax LENGTHB( string1 ) Parameters string1: string for getting the length. Return This function returns a numeric value. Example 1 Select lengthb('javatpoint') from dual; Example 2 Select lengthb('oracle') from dual; TopicOracle String ...
1 min read
LENGTH()
Oracle Function LENGTH is a String function of Oracle. This function returns the size of the given string. Syntax LENGTH( string1 ) Parameters string1: string for getting the length. Return This function returns a numeric value. Example 1 Select length('oracle') from dual; Example 2 Select length('javatpoint') from dual; TopicOracle String ...
1 min read

DUMP

Syntax

Parameters

Return

Example 1

Example 2

Contact info

Follow us

Tutorials

Interview Questions

Online Compiler

Python

Java

.Net Framework

AI, ML and Data Science

Cloud Technology

B.Tech and MCA

Web Technology

PHP

Software Testing

Technical Interview

Java Interview

Python

Web Interview

Database Interview

B.Tech / MCA

Important Interview

Software Testing Interview

Company Interviews

Online Compilers

Multiple Choice Questions

Oracle Tutorial

Oracle Tables

Oracle Views

Oracle Query

Oracle Clauses

Oracle Operators

Oracle Joins

Oracle Advance

Oracle Misc

Interview Questions

Oracle Math Function

Oracle String Function

DUMP

Syntax

Parameters

Return

Example 1

Example 2

Related Posts

LENGTHC()

SOUNDEX()

RTRIM()

RPAD()

SUBSTR()

ASCIISTR

Oracle VSIZE() Function

REGEXP_INSTR()

LENGTHB()

LENGTH()

Subscribe to Tpoint Tech

Contact info

Follow us

Tutorials

Interview Questions

Online Compiler