Oracle/plsql:length Function-from Cyber

Oracle/plsql:LENGTH Function

This is the Oracle/plsql LENGTH function with syntax and examples of Oracle tutorial explains.

Description

The Oracle/plsql length function returns the length of the specified string.

Syntax

The syntax for the LENGTH function in Oracle/plsql is:

LENGTH( string1 )

Parameters or Arguments

String1

The

string to return the length for.

Note: If string1 is null and then the LENGTH function would return NULL.

Applies To

The LENGTH function can be used in the following versions of Oracle/plsql:

• Oracle 12c, Oracle 11g, Oracle 10g, Oracle 9i, Oracle 8i

Example

Let's look at some Oracle LENGTH function examples and explore, the length function in Oracle/plsql.

For example:

LENGTH(NULL)Result: NULLLENGTH(‘‘)Result: NULLLENGTH(‘ ‘)Result: 1LENGTH(‘Tech on the Net‘)Result: 15LENGTH(‘Tech on the Net ‘)Result: 16

Oracle/plsql:length Function-from Cyber