Oracle - PL/SQL - LENGTH Function

In Oracle/PLSQL, the length function returns the length of the specified string.

The syntax for the length function is:

length( string1 )

string1 is the string to return the length for. If string1 is NULL, then the function returns NULL.

Applies To:

· Oracle 8i, Oracle 9i, Oracle 10g, Oracle 11g

For example:

length(NULL)

would return NULL.

length('')

would return NULL.

length('Information')

Would return 11