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 Tue Oct 19 1999 - 14:12:14 CDT
