>From: Mark Townsend <markbtownsend@sbcglobal.net>

> > There has always been some discussion about which approach is more
> > "correct". Obviously we at Oracle think this approach is better, for a
> > number of really good reasons. We could also do temp tables the same way
> > as informix and SQL Server, but have chosen to not implement them yet,
> > also for a number of good reasons. It does make migration from these
> > databases to Oracle a little problematic however
>

Now why would anyone want to go and do that? It would be akin to trading in
a perfectly good Porche 911 Turbo on a Toyota toy car.

Seriously.

Under Oracle the temp table isn't temporary. As an object, the definition of
the temp table is persistant thus forcing each "user" er schema on the
instance, to reserve that name for a specific meaning.

And it means that unless you index your column up front, any schema which is
currently using the table, will prohibit you from adding an index to the
temp table. Not a good idea an not a good design.

The dynamic ability to create a temp table on the fly is a very good idea
and its kind of implied by the name temp and the std sql syntax.

Is this to say that Oracle is "wrong" and IDS is "right". Hardly. Its a
design philosophy and you can see that Oracle carries a lot of baggage with
its design.

This isn't to say that IDS is perfect, but its design and flexibility lends
itself to easier adoption of advancements in technology than either DB2 and
Oracle. But lets also be real. Both DB2 and Oracle trace their roots to the
mainframe. Different beast.

As a developer who supports multiple databases, I can appreciate the best
and hate the worst of all of them. On the issue of temp tables and how
Oracle defines a "user", Oracle blows and there isn't any thing that they
can do to fix that in the short term.

I will say one thing... Oracle has definitely done a good job of
brainwashing their dbas.

__________________________________________________ _______________
Capture the missing critters!** Play Search Queries and earn great prizes.
http://club.live.com/search_queries....ltextlink1_oct