Re: How to determine the length of the biggest varchar2 column in a table?

Maxwell MacLeod wrote:

> does anyone know how to do this? For example, if I had a field "name",
> which is varchar2(2000). One value is "Max" and another "Jeromino", I
> need to know the length of Jeromino.

  select max(length(name)) from tablename;

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841