Home » SQL & PL/SQL » SQL & PL/SQL » Count row
Count row [message #229939] Tue, 10 April 2007 06:33 Go to next message
akkumar81
Messages: 144
Registered: February 2007
Location: india
Senior Member

Hi,

Is there any way count total rows in a table.

select count(*) from vemv_agskill;

any other query?

arun..
Re: Count row [message #229941 is a reply to message #229939] Tue, 10 April 2007 06:35 Go to previous messageGo to next message
Maaher
Messages: 7062
Registered: December 2001
Senior Member
Gather the table statistics and do a query of USER/ALL/DBA_TABLES. The NUM_ROWS column might be interesting.

MHE
Re: Count row [message #229944 is a reply to message #229939] Tue, 10 April 2007 06:38 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
SEARCH
Why not? You can use
select count(0) from vemv_agskill;
select count(1) from vemv_agskill;
select count(1.0/2.0) from vemv_agskill;
By
Vamsi
Re: Count row [message #229956 is a reply to message #229944] Tue, 10 April 2007 07:19 Go to previous messageGo to next message
pavuluri
Messages: 247
Registered: January 2007
Senior Member
what is diff bettween those three

select count(0) from vemv_agskill;
select count(1) from vemv_agskill;
select count(1.0/2.0) from vemv_agskill;

thanks
srinivas
Re: Count row [message #229957 is a reply to message #229956] Tue, 10 April 2007 07:20 Go to previous messageGo to next message
Michel Cadot
Messages: 64098
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
letters Razz

Regards
Michel
Re: Count row [message #229959 is a reply to message #229957] Tue, 10 April 2007 07:21 Go to previous messageGo to next message
pavuluri
Messages: 247
Registered: January 2007
Senior Member
no difference?

thanks
srinivas
Re: Count row [message #229975 is a reply to message #229959] Tue, 10 April 2007 08:10 Go to previous messageGo to next message
vamsi kasina
Messages: 2107
Registered: October 2003
Location: Riyadh, Saudi Arabia
Senior Member
Michel,
No. Digits. Laughing
Srinivas,
you can check this.

By
Vamsi
Re: Count row [message #230342 is a reply to message #229939] Wed, 11 April 2007 10:48 Go to previous message
Ericle
Messages: 44
Registered: April 2006
Location: United States of America ...
Member

I like to count wolves while I'm going to sleep instead of sheep. Neutral
Previous Topic: Insert with sum statement doesn't work
Next Topic: Help with Package concepts
Goto Forum:
  


Current Time: Fri Dec 02 12:31:45 CST 2016

Total time taken to generate the page: 0.08507 seconds