Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Temp tables Oracle versus Sybase

Re: Temp tables Oracle versus Sybase

From: Terry Dykstra [TeamPS] <no_spam_tdykstra_at_cfol.ab.ca>
Date: 14 Apr 98 18:37:37 GMT
Message-ID: <01bd67d4$93d3c960$3301020a@tdykstra>


Take a look at PL/SQL tables.
--
Terry Dykstra [TeamPS]
Canadian Forest Oil Ltd.

Denis Langlais <langlais_at_ibm.net> wrote in article <352FA47F.2B0C_at_ibm.net>...
> 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
>
>
>
Received on Tue Apr 14 1998 - 13:37:37 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US