Re: Temp tables?

From: Shmooth <shmooth_at_yahoo.com>
Date: Wed, 20 Oct 1999 23:17:40 GMT
Message-ID: <380E4C75.BA500AB0@yahoo.com>

I looked at the 'Getting to Know Oracle8i' book and the 'Temporary Tables(2-42)' referred me to the 'Oracle Concepts' documentation, but all I could find there were references to temp 'tablespaces' and 'segments'.

Where can I find docs on temp tables? Like SQL to create? etc.?

Thanks.

"Kevin P. Fleming" 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
> >
> >
Received on Wed Oct 20 1999 - 18:17:40 CDT