Re: temp tables in oracle

From: Dante <dnotari_at_my-dejanews.com>
Date: Tue, 11 May 1999 18:35:39 GMT
Message-ID: <7h9t9r$e52$1@nnrp1.deja.com>

Alex,
temporary tables were introduced with Oracle version 8.1.5.

But for the application you mention, there is no need to use a temporary table to join it. Just join the original table.

Regards
Dante

In article <3738677C.2DC2357E_at_macromedia.com>, alex menendez <amen_at_macromedia.com> wrote:
> hello, all
>
> Is there anyway to create a temp table in oracle then select a number
of
> fields into it for a subsequent
> join with another table?
>
> Most of my sql experience has been with sybase and I am new to oracle.
> I know that in sybase you are able to create temp tables on the fly
with
> the #table_name notation.
> These tables are kept in memory until the user logs out of his or her
> sql session.
>
> Does such a thing exist in the oracle world?
>
> thanx in advance,
> -amen
>
>

--== Sent via Deja.com http://www.deja.com/ ==-- ---Share what you know. Learn what you don't.--- Received on Tue May 11 1999 - 13:35:39 CDT