A pipelined table function can return a collection of rows (either a nested table or an array). You can query the returned collection the same way you query a physical table. You can also assign the collection to a collection variable.
Applicability
This topic applies only to OceanBase Database Enterprise Edition. OceanBase Database Community Edition provides only MySQL mode.
You can add the TABLE clause to the SELECT statement to call a pipelined table function. Example:
SELECT * FROM TABLE(table_function_name(parameter_list))
The PIPELINED keyword identifies a pipelined table function. The return value of a pipelined table function must be a collection. The PIPE ROW statement in the function returns a single element of the collection. The function ends with an empty RETURN statement, to indicate that execution is completed.