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
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.