Re: Need SQL Server Temp Table equivalent (challenge!)

Daniel,

I have done my best looking for answers. And I have not ignored any advise. Thanks for giving me another thing to look at: NDS. But your suggestion of DynamicSQL and DBMS_SQL proved that you still missed my point. Yes you can use DBMS_SQL to construct your table dynamically, but the resulting table is visible to ALL sessions. Do you agree to this point? Even if you construct a temp table, the table is still fixed in format. Do you agree this point? So for the time you used to type the reply, can you write a very "easy" pseudo code to do what you said can be done? Frankly I tried and it simply didn't work the way you described. I am hoping I am wrong.

Kin Received on Tue Jul 22 2003 - 20:43:33 CDT