PL/SQL Length

Oracle PL/SQL Length Function

The Length function returns the length of the specified string.

The Length Function syntax:

length( string )

Example:

select length(NULL) from dual;
would return NULL

select length('') from dual;
would return NULL

select length('Learn Oracle Lesson') from dual;
would return 19