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

max_at_virtualf.com (Maxwell MacLeod) wrote:
>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.
>

Hi there,

Try the following query

select max(length(column)) from table;

Regards

N.Prabhakar Received on Wed Jan 15 1997 - 00:00:00 CST