Home » SQL & PL/SQL » SQL & PL/SQL » using COUNT for long list of records possible? (Oracle SQL)
using COUNT for long list of records possible? [message #296700] Mon, 28 January 2008 13:56 Go to next message
orayoh
Messages: 22
Registered: May 2006
Location: Ontario
Junior Member
hello,

I have a list of tables, that I would like to check the count for. The list is quite long, so I am wondering if there is a easy way to check the number of rows (using the count(*)) for each table...but all at once.

Thanks,
orayoh Smile
Re: using COUNT for long list of records possible? [message #296701 is a reply to message #296700] Mon, 28 January 2008 14:02 Go to previous message
Michel Cadot
Messages: 64152
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
This is asked about each month.
Please search BEFORE posting.

You can use ALL_TABLES.NUM_ROWS if statistics are up to date.

Regards
Michel
Previous Topic: replace function
Next Topic: Pl/Sql detail e-guides
Goto Forum:
  


Current Time: Sun Dec 11 00:14:08 CST 2016

Total time taken to generate the page: 0.07935 seconds