single-row function: "functions return a single result row for every row of a queried table or view. "

Multiple row functions: "functions return a single result row based on groups of rows, rather than on single rows."

an example using scott schema emp table:

select empno, ename, to_char(sal, '9,999.99') from emp; --here to_char is a single row function

select deptno, sum(sal) from emp group by deptno; --here sum() is a multiple row function.

Multiple row functions: "functions return a single result row based on groups of rows, rather than on single rows."

an example using scott schema emp table:

select empno, ename, to_char(sal, '9,999.99') from emp; --here to_char is a single row function

select deptno, sum(sal) from emp group by deptno; --here sum() is a multiple row function.