OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Count row

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Count row [message #229939]

Tue, 10 April 2007 06:33

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..

Report message to a moderator

Re: Count row [message #229941 is a reply to message #229939]

Tue, 10 April 2007 06:35

Maaher
Messages: 7065
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

Report message to a moderator

Re: Count row [message #229944 is a reply to message #229939]

Tue, 10 April 2007 06:38

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

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

Report message to a moderator

Re: Count row [message #229956 is a reply to message #229944]

Tue, 10 April 2007 07:19

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

Report message to a moderator

Re: Count row [message #229957 is a reply to message #229956]

Tue, 10 April 2007 07:20

Michel Cadot
Messages: 68728
Registered: March 2007
Location: Saint-Maur, France, https...

Senior Member
Account Moderator

letters

Regards
Michel

Report message to a moderator

Re: Count row [message #229959 is a reply to message #229957]

Tue, 10 April 2007 07:21

pavuluri
Messages: 247
Registered: January 2007

Senior Member

no difference?

thanks
srinivas

Report message to a moderator

Re: Count row [message #229975 is a reply to message #229959]

Tue, 10 April 2007 08:10

vamsi kasina
Messages: 2112
Registered: October 2003
Location: Cincinnati, OH

Senior Member

Michel,
No. Digits. Laughing

Srinivas,
you can check this.

By
Vamsi

Report message to a moderator

Re: Count row [message #230342 is a reply to message #229939]

Wed, 11 April 2007 10:48

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

Report message to a moderator

Previous Topic:	Insert with sum statement doesn't work
Next Topic:	Help with Package concepts

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sat Dec 14 15:53:53 CST 2024