Using a returned set of tuple as a table in another query.
Marius2Dec 9 2006 — edited Dec 9 2006I want to do the following, and I'm having problem finding a solution.
I want a function a that returns a set of rows and then I want do do a select statement later where the return value from a is treated as a table in the from statement.
One example.
SELECT * FROM a(parameter1, parameter2, parameter3) as tab1(a number,b number, c date) WHERE tab1.a > 10;
Why do I want to do this? I'm porting something from Postgres to Oracle and the original system does this all the time. Or is there another work around if this can not be translated directly?