Re: Sybase vs Oracle: Temp Tables

Fuzzy wrote in message <35d22eae.3183691_at_newshost.interact.net.au>...
>On 12 Aug 1998 11:37:03 -0500, arenson_at_swan.imgen.bcm.tmc.edu (Andrew
>D. Arenson) wrote:
>
>>

 [...]
>> In Sybase, I'm used to creating temporary tables on the fly
>>without having to run the 'create table' command, by using the
>>following syntax:
>>
>> select ...
>> into #TMP TABLE
>> from ...
>> where ...
>>
>>This doesn't work in Oracle (as far as I know). In fact, the
>>'SELECT ... INTO' syntax appears to be used for some sort of single
>>row loading of data into variables that I haven't fully explored yet.
>>

 [...]
>Oracle is the only major RDBMS that doesn't have this. (Sybase, MS SQL
>Server, Informix, DB2 all have it)
>

The funny part is that although the Oracle RDBMS doesn't have this, Oracle Rdb (Oracle's other relational database) does. Maybe someday they will take the technology and migrate it into their core database.                                                        

Barry L. Wallis, Senior Systems Engineer Science Applications International Corporation 4161 Campus Point Court
San Diego, CA 92121

voice: (619) 646-9891, fax: (619) 646-9327 mailto: Barry.L.Wallis_at_cpmx.saic.com                                                        

--