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: (more…)

Filed in Oracle with 4 Comments | Tags: ,


COUNT(*) vs COUNT(1)

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

Filed in Oracle, Tips with 1 Comment | Tags: