As far as I know, there's no difference.

dgaikwad escribió:

>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.
>
>
>---------------------------------------------------------------------
>TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
>To post a dba job: http://jobs.lazydba.com
>To Subscribe : http://www.LazyDBA.com
>To unsubscribe: http://www.lazydba.com/unsubscribe.html
>
>
>
>
>
>

Oracle LazyDBA home page