What are SQL functions in oracle?

Answer

There are two types of functions – Single row that operates row by row. Group function operates on multiple rows.

Functions that fall under single functions are Date, Numeric, Character, Conversion and miscellaneous function

Functions that fall under group functions are avg, max, min, count, and sum.