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: Tmp tables in oracle?!@#!

Re: Tmp tables in oracle?!@#!

From: Kevin P. Fleming <kfleming_at_access-NOSPAM-laserpress.com>
Date: Fri, 08 Oct 1999 18:11:35 GMT
Message-ID: <rtqL3.14657$%a1.48439@news.rdc1.az.home.com>


Only in 8.1.5 and above are temporary tables available, and they work very much like SQL Server's temporary tables, except they're "pre-created" by the DBA, the application just fills them in and queries them.

someone <tschraer_at_my-deja.com> wrote in message news:7tkqs4$hog$1_at_nnrp1.deja.com...
> I am some what new to Oracle. I have been working with SQL Server for
> the last couple of years and they have a feature that lets you create
> temporary tables on the fly. you can either create a public table or a
> private temporary table. Is there a way in oracle to create a
> temporary table, in a procedure that I can use to return result sets to
> the client.
>
> Thanks for the help
>
> Tom
>
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Fri Oct 08 1999 - 13:11:35 CDT

Original text of this message

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