A table function is a function that can act like a table inside a SELECT statement. The function returns a collection, and the SQL engine converts that collection into rows and columns that can be manipulated with standard SQL operations (joins, unions, where clauses, etc.).
Far and away the most popular post on this blog is an introduction to a series of articles on table functions:
Given that level of interest in a very interesting feature of PL/SQL, I thought it would be a good thing to give you even more resources to learn about table functions.
So I put together a FREE class at the Oracle Dev Gym on PL/SQL table functions. It consists of four modules and gives you a solid grounding in table function fundamentals:
Each modules consists of a video that covers the basics, followed by a LiveSQL tutorial that dives into more of the details, and gives you an opportunity to run and play with the code. We then finish up the module with quizzes to reinforce and deepen the new knowledge you've just gained.
To get the most out of this class, you should be comfortable writing SELECT statements and PL/SQL functions. Knowledge of collections is a big plus, but I cover the fundamentals in the first module.
Dev Gym classes are "mini-MOOCs" - they are fully online and on-demand classes but are relatively "light" in the amount of time you will need to complete them. You can start the class whenever you have time, take breaks as needed, and when you are finished, print out a certificate of completion.
I hope you will find the class helpful. Just click on this link for more information and to register: