Oracle LENGTH function

Preamble

The Oracle/PLSQL LENGTH function returns the length of the specified string.

Syntax of the Oracle/PLSQL LENGTH function

LENGTH( string1_id )

Parameters and function arguments

• string1_id – string whose length the function returns. string1 can be CHAR, VARCHAR2, NCHAR, NVARCHAR2, CLOB, or NCLOB.

The LENGTH function returns a numeric value.

If string1 is NULL, the LENGTH function will return NULL.

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

Let’s consider some examples of the LENGTH function and learn how to use the LENGTH function in Oracle PLSQL.

SQL> SELECT LENGTH(NULL) FROM DUAL;

--Result: NULL

SQL> SELECT LENGTH('') FROM DUAL;

--Result: NULL

SQL> SELECT LENGTH(' ') FROM DUAL;

--Result: 1

SQL> SELECT LENGTH('1') FROM DUAL;

--Result: 1

SQL> SELECT LENGTH('Antiquities Shop') FROM DUAL;

--Result: 16

SQL> SELECT LENGTH('Antiquities Shop ') FROM DUAL;

--Result: 17

Tutorial: How to find the length of column in Oracle SQL – Length Function

About Enteros

​​​​Enteros offers a patented database performance management SaaS platform. It proactively identifies root causes of complex business-impacting database scalability and performance issues across a growing number of clouds, RDBMS, NoSQL, and machine learning database platforms.​