Diff Between Count( * ) and Count( 1 )

Diff Between Count( * ) and Count( 1 )

 

  

Hi DBA's

Can anyone tell me Which is to use COUNT(*) or COUNT(1) and Why?

What is exact Difference between them?



Thanks & Regards,
Dinesh G.

Oracle LazyDBA home page