Oracle PL/SQL: Regular vs. Pipelined Table Functions

Table functions are specialized PL/SQL functions that return collections of rows and can be queried directly in the FROM clause of a SQL query as if they were physical database tables. Key Comparison: Regular vs. Pipelined Table Functions Feature Regular Table Function Pipelined Table Function Memory Allocation High (buffers entire collection in... Weiterlesen