Search results
Table Functions. Table functions are used to return PL/SQL collections that mimic tables. They can be queried like a regular table by using the TABLE operator in the FROM clause. Regular table functions require collections to be fully populated before they are returned.
Learn what table functions are, how they work, and how to use them in SQL statements. This tutorial covers the basics of table functions, such as creating, calling, and querying them, with examples and tips.
Pipelined table functions are table functions that return or “pipe” rows back to the calling query as the function produces the data in the desired form—and before the function has completed all of its processing.
Table functions are functions that produce a collection of rows (either a nested table or a varray) that can be queried like a physical database table. You use a table function like the name of a database table, in the FROM clause of a query. A table function can take a collection of rows as input.
This tutorial covers the fundamental features and behavior of pipelined table functions. You may also want to explore parallel-enabling pipelined table functions. Follow the links at the bottom of this tutorial for more details on this topic.
Table functions are very cool: they are functions that return collections, and can be called in the FROM clause of a SELECT, as if it were a table or view. In this session, Steven Feuerstein will start with a quick intro to and demos of table functions.
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! This class starts with table function fundamentals, then explores streaming table functions, and finishes up with a look at pipelined table functions.
