The Oracle and PL/SQL LENGTH function returns the length of the specified string.
The general format is:
LENGTH(char)
Example 1:
SELECT LENGTH('JOHN WILLIAMS') FROM DUAL;
returns:
13
Example 2:
SELECT LENGTH('JOHN WILLIAMS ') FROM DUAL;
returns:
20