<ul><li>A table function is a user-defined function that returns a collection (e.g., a table or an array) that can be queried like a table in SQL.</li><li>Syntax of a table function:</li><li>CREATE OR REPLACE FUNCTION function_name RETURN collection_type IS BEGIN RETURN result_collection; END;</li><li>A pipelined function is a specialized table function that returns rows incrementally (one by one or in small batches) instead of processing and returning the entire collection at once.</li></ul>

Table functions and Pipelined functions in PLSQL | Best Explanation

Discover more