Oracle LENGTH() Function

17 Mar 2025 | 1 min read

LENGTH is a String function of Oracle. This function returns the size of the given string.

Syntax

Parameters

string1: string for getting the length.

Return

This function returns a numeric value.

Example 1

Example 2

Next TopicOracle String

← prev next →

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
UPPER()
Oracle Function UPPER is a String function of Oracle. This function is used to convert the given string into uppercase. Syntax UPPER(string1) Parameters string1 : string to be converted. Return It returns the string value. Example 1 SELECT upper('javatpoint') FROM dual; Example 2 SELECT upper('oracle') FROM dual; TopicOracle String ...
1 min read
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
LTRIM()
Oracle Function LTRIM(str) is a String function of Oracle. This function returns the string by removing given characters from left side. Syntax LTRIM( string1 [, trim_string] ) Parameters string1 : string to be trimmed from left-hand side. trim_string : it is optional. It is the string to be removed from the...
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
LENGTH4()
Oracle Function LENGTH4 is a String function of Oracle. This function returns the size using UCS4 code points of given string. Syntax LENGTH4( string1 ) Parameters string1: string for getting the length. Return This function returns a numeric value. Example 1 Select length4('javatpoint') from dual; Example 2 Select length4('oracle') from dual; TopicOracle String ...
1 min read
REGEXP_SUBSTR()
Oracle Function REGEXP_ SUBSTR is a String function of Oracle. It is an extension of SUBSTR function. This function is used for pattern matching in substring from a string. Syntax REGEXP_SUBSTR( string, pattern [, start_position [, nth_appearance [, match_parameter [, sub_expression ] ] ] ] ) Parameters String : string...
4 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
CHR
is a String function of Oracle. This function returns all the characters of the given ASCII code. Syntax (number) Parameters number: It is the NUMBER code which is used to retrieve the character Returns This function returns a string value. Example 1 SELECT (65) FROM DUAL; Example 2 SELECT (69) FROM DUAL; TopicOracle String ...
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

We provides tutorials and interview questions of all technology like java tutorial, android, java frameworks

Contact info

G-13, 2nd Floor, Sec-3, Noida, UP, 201301, India

hr@tpointtech.com

+91-9599086977

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

Oracle LENGTH() Function

Syntax

Parameters

Return

Example 1

Example 2

Related Posts

SOUNDEX()

UPPER()

LENGTHC()

LTRIM()

ASCIISTR

LENGTH4()

REGEXP_SUBSTR()

RTRIM()

CHR

RPAD()

Subscribe to Tpoint Tech

Contact info

Follow us

Tutorials

Interview Questions

Online Compiler