Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Temp tables Oracle versus Sybase
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
![]() |
![]() |