PL/SQL Count

The COUNT function returns the number of rows returned by the query.

Count syntax

COUNT( expression )

Count example

STUDENT_ID FIRST_NAME LAST_NAME CITY
1 Daniel SCOTT New York
2 Anthony SIMMONS Chicago
3 Sophia THOMPSON Los Angeles
select count(*) from students;

Result: 3