Oracle PL/SQL Count Function

The Count function returns the number of rows in a query.

The Count Function syntax:

count( expression )

Example 1:

Select count(e.empno) From emp e;

Example 2:

Select e.ename, count(distinct e.job)
From emp e
Where e.sal>1300 
Group By e.ename;