Query table name and average row length from user_object_tables : user_object_tables « System Tables Data Dictionary « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. System Tables Data Dictionary
  3. user_object_tables
SQL>
SQL>
SQL> select table_name, avg_row_len from user_object_tables;

no rows selected

SQL>
SQL>








30.89.user_object_tables
30.89.1.Query table name and average row length from user_object_tables