From the Oracle SQL Reference: If you specify 'expr' then COUNT returns the number of rows where 'expr' is not null.http://download-west.oracle.com/docs/cd/B10501_01/server.920/a96540.pdfCOUNT can take virtually any parameter, including 1, *, or a column.