My understanding is that avg_row_len is just that - it is the average real length of the rows, which is less than the maximum because varchar2() only takes the space needed (plus a little bit) unlike char() where trailing spaces are included. If there are no rows this average can't be calculated. I guess it should be NULL not zero!
Last edited by DaPi; 12-19-2002 at 09:35 AM.
"The power of instruction is seldom of much efficacy except in those happy dispositions where it is almost superfluous" - Gibbon, quoted by R.P.Feynman