Re: Temporary Tables

From: Daniel Morgan <dmorgan_at_exesolutions.com>
Date: Thu, 21 Nov 2002 23:33:26 GMT
Message-ID: <3DDD6D42.E6BBEFC2@exesolutions.com>

Wayne R Happ wrote:

> Does Oracle has equivalent functionality to Sybase's temporary tables in tempdb?
>
> Something like Sybase's #table i.e.
>
> Example Sybase SQL
>
> create #table (one char(10))
>
> Wayne

Others have told you that the answer to your question is yes.

I want to emphasize as you are coming from Sybase ... that doing so is about 99.999% unnecessary in Oracle and is greatly frowned upon for reasons of performance and scalability.

If it ain't broke ... don't try to fix it.

Dan Received on Thu Nov 21 2002 - 17:33:26 CST