SQL FUNCTIONS

Group Functions in Oracle

Group functions execute on a group of rows and return one result per group. Group functions ignore null values.

Commonly used group functions:

• COUNT
• SUM
• AVG
• MAX
• MIN

COUNT:

COUNT function has 3 variants.

• COUNT(*)
• COUNT(column

…

Single Row Functions in Oracle

There are two types of SQL functions available in oracle:

• Single row function
• Multiple row function

Single row function: It works on a single row and returns one result for each row.

Multiple row function:…