Re: TEMPORARY Table in Oracel 8i

From: Klaus Zeuch <KZeuch_at_nospamhotmail.com>
Date: 2000/08/08
Message-ID: <8mpv3q$jvt$10$1@news.t-online.com>#1/1

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_at_my-deja.com> schrieb im Newsbeitrag news:8mpq56$f26$1_at_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.
Received on Tue Aug 08 2000 - 00:00:00 CDT