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>--   w ww  .j  a  v  a 2 s. co  m
SQL> SELECT LENGTH('test') FROM dual
  2