Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Temporary Table
Yes, and you may not need to do that in Oracle. I have been using Oracle
since version 5 and never needed to use a temporary table. Just use
standard SQL to access the information. Unlike some other database products
readers don't block writers and writers don't block readers. Also views in
Oracle are not bad things to be avoided. You can use a view.
If you feel you just gotta have temporary tables do as Fraser suggests and
look up globabl temporary tables in the docs.
Jim
"Hugo Habicht" <xyzabc103_at_hotmail.com> wrote in message
news:25wW8.198731$IR.3020849_at_news.chello.at...
> Hi there,
>
> I´m coming from SQL Server and I used temporary Tables for storing
temporary
> Data. The Problem is we use the Database in MultiUser environment. In SQL
> Server a temporary Table exists only in the UserProcess. So each User
> creates his own Table.
> Is this possible in Oracle or is there a Workaround?
>
> thanks
>
> Hugo
>
>
Received on Tue Jul 09 2002 - 08:31:46 CDT