How to count the number of rows in multiple Oracle Tables
Posted on 2016-10-31
Hi - I've been searching for a simple solution, but haven't found anything I can understand enough to make work.
I have 78 tables in my Oracle schema. I need to create a select statement that will count the number of rows in each table, and display it in a format that can be exported to csv (two columns: one for the table name, the second for the number of rows). I need to use count(*) because the tables are not analyzed frequently (it is a test system).
I've seen several solutions out there, but my sql skills aren't very strong, and I've not been able to find something I can use.
Thanks for any help!