PL/SQL Length

The LENGTH function returns the length of string.

Length syntax

LENGTH( string )

Length example

 
select length('') from dual;	

Result: (null)


select length(NULL) from dual;

Result: (null)


select length(12345) from dual;

Result: 5


select length('12345') from dual;

Result: 5


select length('12,345.89') from dual;

Result: 9


select length('Reference') from dual;

Result: 9


select length('PL/SQL Reference') from dual;	

Result: 16