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: Need SQL Server Temp Table equivalent (challenge!)

Re: Need SQL Server Temp Table equivalent (challenge!)

From: Jim Kennedy <kennedy-downwithspammersfamily_at_attbi.net>
Date: Sat, 22 Jan 2005 10:24:16 -0800
Message-ID: <teudncuMKJigB2_cRVn-2A@comcast.com>

"wile" <wilekayote_at_yahoo.com> wrote in message news:1106085796.405365.187900_at_f14g2000cwb.googlegroups.com...
> Wrt to the following comment:
> "as Oracle's lack of capability. One can easily create temporary tables
> with dynamically created columns in Oracle. One can also be frequently
> be reminded that it is bad design that only exists in SQL Server
> because of the weaknesses of the underlying architecture and that
> Microsoft is working like crazy to overcome it in future versions"
>
> As a SQL Server and Oracle programmer I think the point is that SQL
> Server is just so much simpler/intuative. Yes Oracle may have some
> super powerful features but they are just so bloody hard to find. It
> may excite some people to read though manuals on their weekends but for
> those of us who dont live to code Oracle just seems to make things hard
> that don't need to be.
>

Creating a temp table to do a query doesn't seem easier to me than just doing the query. Isn't just doing the query simpler? (Oracle) Jim Received on Sat Jan 22 2005 - 12:24:16 CST

Original text of this message

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