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(Column_Name))

   FROM Your_Table;

-- 
Hui, Kwok Miu (Xu, Guo Miao)         E-Mail: huikomix_at_dt.com.hk
Assistant MIS Manager                Tel   : (00852)2589 3369
Cho Yang (Hong Kong) Co., Ltd.       Fax   : (00852)2559 3049