Use the result of a PL/SQL routine as if it were a table.
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-functionI want to execute dynamic query in my pipelined function and return results of this query. Is it possible to …
oracle plsql execute-immediate pipelined-functionCREATE OR REPLACE TYPE myObjectFormat AS OBJECT ( A VARCHAR2(200), B INTEGER, C INTEGER ) / CREATE OR REPLACE TYPE myTableType AS TABLE …
oracle oracle10g pipelined-function