Is there any way to accomplish something like this in PL/SQL...
select a.col1, a.col2, a.col3, myFunc(a.id) from myTable a;
and the result be more than 4 columns? So basically, is there a way for a function to return or pipe more than one column back? The number needed is known and set in stone, it's 3. So this query would return 6 columns. I know I could call the myFunc() 3 separate times but the amount of processing would be tripled.
I've been playing around with pipeline functions but it doesn't appear they can be used to do this.
Oracle Database 11g Enterprise Edition Release 11.2.0.2.0 - 64bit
Production PL/SQL Release 11.2.0.2.0 - Production
Thanks!