Re: Varchar2

How about:

select avg(data_length) from all_tab_columns where data_type='VARCHAR2';

--
Matt Brennan
SQL*Tools Specialist
GERS Retail Systems
9725-C Scranton Road
San Diego, California 92121
1-800-854-2263
mbrennan_at_gers.com
(Original email address is spam-blocked.)

Robert K. Tucker <rat_at_nospam.epnet.com> wrote in article <01bd9ac0$c52645a0$d35a0645_at_iguana>...
> Is there an easy way to get the average column length of a Varchar2
field?
> This is for re-sizing guestimates of indexed columns.Thanx
> -rkt
>
Received on Fri Jun 19 1998 - 09:47:01 CDT