Home » SQL & PL/SQL » SQL & PL/SQL » COUNT THE NUMBER OF ROWS IN A TABLE
COUNT THE NUMBER OF ROWS IN A TABLE [message #220313] Tue, 20 February 2007 03:48 Go to next message
chinmay_uce02
Messages: 11
Registered: January 2007
Junior Member
HI ALL,
MY QUERY IS "IS THERE ANY QUERY TO COUNT THE NUMBER OF ROWS IN A TABLE?". ANY HELP.


THANKS IN ADVANCE
CHINMAY
Re: COUNT THE NUMBER OF ROWS IN A TABLE [message #220316 is a reply to message #220313] Tue, 20 February 2007 03:50 Go to previous messageGo to next message
pavuluri
Messages: 247
Registered: January 2007
Senior Member
select count(*) from table;
thanks
srinivas
Re: COUNT THE NUMBER OF ROWS IN A TABLE [message #220349 is a reply to message #220316] Tue, 20 February 2007 06:08 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
If your stats are up to date, have a look at the NUM_ROWS column in USER/ALL/DBA_TABLES.

MHE
Re: COUNT THE NUMBER OF ROWS IN A TABLE [message #220427 is a reply to message #220349] Tue, 20 February 2007 12:19 Go to previous messageGo to next message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
Maaher wrote on Tue, 20 February 2007 06:08
If your stats are up to date, have a look at the NUM_ROWS column in USER/ALL/DBA_TABLES.

MHE

true, but it will be accurate only if no deletes or inserts have been done since the statistics were done.
Re: COUNT THE NUMBER OF ROWS IN A TABLE [message #220528 is a reply to message #220427] Wed, 21 February 2007 02:02 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Hence my "if" Wink.

MHE
Re: COUNT THE NUMBER OF ROWS IN A TABLE [message #220709 is a reply to message #220528] Wed, 21 February 2007 11:49 Go to previous message
Bill B
Messages: 1484
Registered: December 2004
Senior Member
Maaher wrote on Wed, 21 February 2007 02:02
Hence my "if" Wink.

MHE


LOL, the reply wasn't for you, it was for the user.
Previous Topic: sqlplus on Windows sends parameter 1: '2>nul'
Next Topic: Run script in OEM
Goto Forum:
  


Current Time: Sat Dec 10 16:45:47 CST 2016

Total time taken to generate the page: 0.05901 seconds