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

Kin Ng wrote:

> Ok guys. I think you all are still missing my points. Here are the
> problems with you way of "dynamic" approach:
>
> 1. You created a PERMANENT table even though you created using
> dynamic sql.
> 2. You can't SCALE because you can't have more than 1 person using
> it...unless you name the table differently every time.
> 3. Regardless, you have to delete it because it is permanent.
>
> I am trying to scale and that's why having a dynamic table that is
> visible to only one session, and each session's table may have
> different table structure are critical. Of course, the system should
> take care of the cleaning up. Being able to do this in a SP
>
> select * from myTempAndTruelyDynamicTable
>
> and return the result set is cool as well. But that's another topic.
>
> Guys, I apologize if I offended any of you. But I still can't see how
> you can do that easily in Oracle.
>
> Oracle's Temp Table solution is close but it still requires fixed
> columns. Just imagine if the Oracle's Temp table structure can be
> changed for each session and won't effect other sessions, then my
> problem is solved.

I'm not offended either. But I am of the opinion that you are doing your darndest to ignore good advice because, for some reason, you don't like it or don't understand it.

Oracle does not require fixed columns if you used NDS or DBMS_SQL.

Why don't you stop spending your time posting messages and try writing dynamic that leverages the information in user_tab_columns.

If your expectation is that someone here is going to do your research ... or your work for you, you are likely mistaken.

You have the requisite information ... it can be easily done with NDS or DBMS_SQL. The ball is in your court.

--
Daniel Morgan
http://www.outreach.washington.edu/extinfo/certprog/oad/oad_crs.asp
damorgan_at_x.washington.edu
(replace 'x' with a 'u' to reply)