msgbartop

News, views, tips and tricks on Oracle and other fun stuff

msgbarbottom

Different ways to count

In Oracle, there are at least three different ways to count the number of records a SQL query returns: Continue reading…

4 Comments | Filed in Oracle | Tags: count, sql

COUNT(*) vs COUNT(1)

Which one to use? COUNT(*) or COUNT(1)? Tom Kyte’s answer.

1 Comment | Filed in Oracle, Tips | Tags: count