[GENERAL] CTE materializing sets?

2012-10-05 Thread Liam Caffrey
Hi, If I run a CTE does that materialize the resulting data in the same (or a similar) way as if I created a temp table and referred to that instead? Or does the CTE keep the set in memory? Regards Liam

[GENERAL] Result sets from functions

2012-04-16 Thread Liam Caffrey
oesn't do it for me but I have to fiddle with the RETURN value of the function definition which I don't want to do. Does anything like this exist? Could anybody recommend an equally effective strategy? Regards Liam Caffrey PS: Posted earlier to plsql-hackers which I think was the wrong place. Sorry. Still looking for feedback. Tnx.