LENGTH function returns the length of a string.
The general format for this function is:
LENGTH(string)
SQL> SQL>-- from w w w .j ava2 s.co m SQL> SELECT LENGTH('test') FROM dual 2