I want to find out the number of records in about 10 different tables in an oracle database. What is the most efficient way of doing this without having to run 10 different 'select count(field1) from table1' queries?
If that's the only way of doing it... how would I write that? As a transaction one after the other? Is there a way of placing each result into an array and then returning that information instead of having to run each query separately from the source code?