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 the MySQL-compatible mode.
You can add the TABLE clause to the SELECT statement to call a pipelined table function. Here is an 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.