Oracle PL/SQL Tutorial/System Tables Data Dictionary/user object tables

Query table name and average row length from user_object_tables

SQL>
SQL>
SQL> select table_name, avg_row_len from user_object_tables;
no rows selected
SQL>
SQL>