COUNT

The Oracle and PL/SQL COUNT function returns the count of an expression.

The general format is:

COUNT([DISTINCT | ALL] n)

Example 1:

SELECT COUNT(*) FROM INVOICE;

returns:

123

Example 2:

SELECT COUNT(DISTINCT ID) FROM INVOICE;

returns:

14