From: "Klaus Zeuch" <KZeuch@nospamhotmail.com>
Subject: Re: TEMPORARY Table in Oracel 8i
Date: 2000/08/08
Message-ID: <8mpv3q$jvt$10$1@news.t-online.com>#1/1
Content-Transfer-Encoding: 8bit
References: <8mpq56$f26$1@nnrp1.deja.com>
X-Sender: 320034664195-0001@t-dialin.net
X-Priority: 3
Content-Type: text/plain; charset=ISO-8859-1
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6600
X-Complaints-To: abuse@t-online.de
X-Trace: news.t-online.com 965771194 10 20477 320034664195-0001 000808 21:46:34
Organization: T-Online
X-MSMail-Priority: Normal
Mime-Version: 1.0
Reply-To: "Klaus Zeuch" <KZeuch@nospamhotmail.com>
Newsgroups: comp.databases.oracle.server


With create global temporary table you can create such a table - but you
have to drop it manually, Oracle only truncates the table (at session's end
if table is created with create....on commit preserve rows or after each
commit  (default) - create... on commit delete rows). The definition of the
temp table is visible to *all* sessions, data is visible to the session that
inserted it. There are several restrictions / limitations - please read the
manual.

Klaus
<pmohanan@my-deja.com> schrieb im Newsbeitrag
news:8mpq56$f26$1@nnrp1.deja.com...
> Hi..All,
>
>    How do i create a temporary table in Oracle 8i, which is only
> available during the current session & gets deleted when we come out of
> the current session.
>
> TIA,
>
> Regard.
>
> Praveen
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.