Oracle Table Sizes: Query Guide

1 year ago
Emily Johnson
1 minute

You can use the following SQL statement to query all table names and row counts:

SELECT table_name, to_char(num_rows,'999,999,999,999') AS num_rows
FROM all_tables
ORDER BY table_name;

This SQL statement will provide the table name and number of data entries for all tables, sorted by table name. To query all tables including system tables, you can use the dba_tables view. If you only want to query tables owned by the current user, you can use the user_tables view.

bannerAds