troubleshooting Question

plsql: get number of records from 10 different tables efficiently

Avatar of AidenA
AidenA asked on
Oracle DatabaseASP.NETSQL
22 Comments1 Solution768 ViewsLast Modified:

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?

Thanks, Aiden
Join our community to see this answer!
Unlock 1 Answer and 22 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 22 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros