Top "Pipelined-function" questions

Use the result of a PL/SQL routine as if it were a table.

SELECT * FROM TABLE(pipelined function): can I be sure of the order of the rows in the result?

In the following example, will I always get “1, 2”, or is it possible to get “2, 1” and can you tell me where …

oracle plsql pipelined-function
PL/SQL - execute immediate in pipelined function

I want to execute dynamic query in my pipelined function and return results of this query. Is it possible to …

oracle plsql execute-immediate pipelined-function
ORA-22905: cannot access rows from a non-nested table item

CREATE OR REPLACE TYPE myObjectFormat AS OBJECT ( A VARCHAR2(200), B INTEGER, C INTEGER ) / CREATE OR REPLACE TYPE myTableType AS TABLE …

oracle oracle10g pipelined-function