Re: Sybase vs Oracle: Temp Tables

Hi Barry,

        Maybe I have been brainwashed by Oracle, but I don't see the need for a temporary table. Other than not having to explicitly create and drop a table what does it buy me to have temporary tables?

regards

Jerry

Barry L. Wallis wrote:
>
> 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
> _______________________________________________________
>
> ---------------------------------------------------------------
>
> Name: Barry L. Wallis.vcf
> Part 1.2 Type: unspecified type (application/octet-stream)
> Encoding: quoted-printable
 

-- 
Jerry Gitomer         	ICT Group
jgitomer_at_ictgroup.com	Langhorne PA
jgitomer_at_yahoo.com 	Opinions are mine not those of ICT Group