TDV has made every effort to support all of the aggregate and analytic functions that Oracle supports. The following table lists the Oracle functions and notes describing how TDV interprets the functions.

Aggregate functions return a single result row based on groups of rows, rather than based on single rows. Aggregate functions can appear in SELECT lists and in ORDER BY and HAVING clauses. They are commonly used with the GROUP BY clause in a SELECT statement, where Oracle Database divides the rows of a queried table or view into groups.

TDV supports the following types of functions for Oracle: