Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Temp tables?
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