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

Try

	SELECT NVL(MAX(LENGTH(name)), 0) name
	FROM your_table_name;

-- 
Vijaya Kumar Vardhineni
Certified Oracle DBA, EDS
Plano, TX

Maxwell MacLeod <max_at_virtualf.com> wrote in article
<32dc1bdc.21148600_at_news.alterdial.uu.net>...


> Hi, 

> 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.

> 

> Any help much appreciated!

> 

> Thanks,

> Max.

> 

>