Table functions are functions that act like tables in a SELECT statement: you can query columns and rows from the array returned by the function! Table functions are a great way to programmatically construct data sets and also play a key role in data warehouses that need to perform multiple transformations of data within a single SQL statement. This class starts with table function fundamentals, then explores streaming table functions, and finishes up with a look at pipelined table functions.
Before starting this class, you should be comfortable with writing SQL SELECT statements and working with PL/SQL collections (primarily nested tables). When the course begins, you will find links at the bottom of this page to help you do just that.