Re: Temp tables Oracle versus Sybase

From: Jerry Gitomer <jgitomer_at_p3.net>
Date: Mon, 13 Apr 1998 23:33:03 -0400
Message-ID: <3532D8EF.163D@p3.net>

Hi Denis,

Okay, I am beginning to see why you want temporary tables. Oracle, in their infinite wisdom, has decided that you don't need them. Oracle would tell you to use views to accomplish your objectives.

Regards

Jerry

Denis Langlais wrote:
>
> I have been working with Sybase recently where "temp tables"
> seem to be a good way to reduce I/O and complicated
> SQL. I can create a temp table which is not affected
> by another user using the same code by the use of "#"
> in front of the table name.
>
> I would like to do the same with Oracle.
> Create a temporary table which will not be conflict with
> someone else running the same code!!
>
> Any ideas
>
> ----
> You can email me: Denis Langlais using the following address
> langlais_at_ibm.net

--
Jerry Gitomer Since I know how to spell DBA I became one. jgitomer_at_p3.net Received on Mon Apr 13 1998 - 22:33:03 CDT