Mega Code Archive

 

Categories / Oracle PLSQL Tutorial / System Tables Data Dictionary

 

Query table name and average row length from user_object_tables

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