Count in Oracle SQL

The COUNT() function is used to count the number of records in a database.

Syntax: 

Select COUNT(*) from table_name;

Example:

we have the table stu shown below:

1. Check the number of records from the table

Select COUNT(*) from stu;

Output

2. Count the record in the Name column:

Select COUNT(Name) from stu;

Output