OraFAQ Forum: Server Administration » What is the difference between count(*) and count(1)?

Home » RDBMS Server » Server Administration » What is the difference between count(*) and count(1)?

Fri, 28 April 2006 13:22

gjayasekar
Messages: 45
Registered: October 2005

Member

Hi,

What is the difference between count(*) and count(1)?

thanks
jai

Fri, 28 April 2006 13:43

andrew again
Messages: 2577
Registered: March 2000

Senior Member

Previous Topic:	Reason for Object invalidation
Next Topic:	handling data's With out down time in production database

Goto Forum:

]

Current Time: Sun Jan 26 15:18:52 CST 2025