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: Temporary Table

Re: Temporary Table

From: Jim Kennedy <kennedy-family_at_attbi.com>
Date: Tue, 09 Jul 2002 13:31:46 GMT
Message-ID: <6BBW8.446465$352.69882@sccrnsc02>


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,
>
> Im 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

Original text of this message

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