Oracle PL/SQL Tutorial/System Tables Data Dictionary/user object tables
Query table name and average row length from user_object_tables
<source lang="sql">
SQL> SQL> SQL> select table_name, avg_row_len from user_object_tables; no rows selected SQL> SQL></source>