how to find record size using a query

[shyam]

Hi all,

Is there a query to find the length of a given table.

thanks
shyam.s

[tamilselvan]

If you analyze table, you can use the following query.

Select avg_row_len from user_tables where table_name = 'YOURTABLE';

Tamil