October 2005
Intermediate to advanced
454 pages
14h 44m
English
When 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 results—just 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.