Oracle SQL - Function LENGTH function

Introduction

LENGTH function returns the length of a string.

The general format for this function is:

LENGTH(string) 

Demo

SQL>
SQL>-- from   w w  w  .j  av a  2 s.c  om
SQL> SELECT LENGTH('test') FROM dual
  2