COUNT() function in PL/SQL
The COUNT() function is used to count the non-null records from a table
Syntax:
SELECT [expression1, expression2, ... expression_n,]
COUNT(aggregate_expression)
FROM table
[WHERE conditions]
[GROUP BY expression1, expression2, ... expression_n];
Explanation:
- expression1, expression2, … expression_n: These are expressions that might be included in the GROUP BY clause
- aggregate_expression: The expression whose non-null values are to be counted.
- table: The table from which to count.
- conditions: The condition on which to filter the table optionally.
Example:
The following query counts the number of records in the table:
SELECT COUNT(*) FROM sample;
Output:
Explanation: We get the output according to the above query.
How to Count Distinct Values in PL/SQL?
PL/SQL is a procedural language designed to allow users to combine the power of procedural language with Oracle SQL. PL/SQL includes procedural language elements such as conditions and loops and can handle exceptions (run-time errors). It also allows the declaration of constants and variables, procedures, functions, packages, types and variables of those types, and triggers.
In this article, we are going to see how we can count distinct values in PL/SQL.