By nature, a function returns a single value. Discuss the difference between how Oracles single-row functions

0 ⤊

By nature, a function returns a single value. Discuss the difference between how Oracles single-row functions

2006-12-05 16:30:14 · 1 answers · asked by Anonymous in Computers & Internet ➔ Programming & Design

By nature, a function returns a single value. Discuss the difference between how Oracles single-row functions and group functions react within a query.

2006-12-05 16:30:37 · update #1

1 answers

Wow, sounds like a question from a test or quiz...

Group functions, such as sum(), avg(), etc. summarize data from the resultset without having to provide a group by clause.

2006-12-05 16:47:23 · answer #1 · answered by BigRez 6 · 0⤊ 0⤋