Re: Temp tables?

From: <billwoods_at_my-deja.com>
Date: Thu, 21 Oct 1999 01:48:29 GMT
Message-ID: <7ulrd9$4eo$1@nnrp1.deja.com>

Oracle is not same as SQL Server and Sybase. Oracle dose not have any temporay table for user own session like Sybase dose. Sybase can create a temporay table by same user in different session. When the session is finished, the temporay table will be deleted by session.

In article <io3P3.2162$hX5.2060_at_news.rdc1.az.home.com>, "Kevin P. Fleming" <kfleming_at_access-NOSPAM-laserpress.com> wrote:
> With Oracle 8i 8.1.5 or later, yes, although the temporary table must
> already exist. The data you place into the table is temporary (by
> transaction or session), but the table itself is permanent.
>
> Francesco Baldi <mail_at_francescobaldi.com> wrote in message
> news:7ud9em$p4t$1_at_nslave1.tin.it...
> > Hello,
> > I'd like to know if it's possible to create temporary tables
> > within stored procedures, like in MS SQL Server
> > (select * into #temptable from sometable)
> >
> > Thanks and regards
> > Francesco Baldi
> >
> >
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Oct 20 1999 - 20:48:29 CDT