3.7. ConclusionWhen you use a table function, the table is the program. What do I mean by that? In effect, a program (your table function) becomes a queryable source of resultsjust like a table. Table functions are perfect for situations where complex logic must be performed by a SELECT statement, as is often the case when you must interface Oracle with third-party applications. Combine that functionality with the extra power provided by parallelizing table functions, and you end up with an extremely handy tool for DBAs. |