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: Temp tables?

Re: Temp tables?

From: Kevin P. Fleming <kfleming_at_access-NOSPAM-laserpress.com>
Date: Fri, 22 Oct 1999 00:53:10 GMT
Message-ID: <WzOP3.3771$hX5.12144@news.rdc1.az.home.com>

No, that's true, each user can't _create_ a temporary table. However, if the
DBA creates one, with name 'xxx', then every session on the system can use
the table 'xxx', but they will all think they have their own separate table
(and the actually do). Once any session is closed, the data it had put into table 'xxx' will be removed. So it's functionally the same, just implemented a little differently.

<billwoods_at_my-deja.com> wrote in message news:7ulrd9$4eo$1_at_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 Thu Oct 21 1999 - 19:53:10 CDT

Original text of this message

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