Question

What is the use of 'SQL% RAW COUNT in PL/SQL programme?

Answer 1

This Oracle tutorial explains how to use the Oracle/PLSQL COUNT function with syntax and examples.

Description

The Oracle/PLSQL COUNT function returns the count of an expression.

Syntax

The syntax for the COUNT function in Oracle/PLSQL is:

SELECT COUNT(aggregate_expression)

FROM tables

[WHERE conditions];

OR the syntax for the COUNT function when grouping the results by one or more columns is:

SELECT expression1, expression2, ... expression_n,

COUNT(aggregate_expression)

FROM tables

[WHERE conditions]

GROUP BY expression1, expression2, ... expression_n;