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
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