SELECT INTO new_table

Oracle´s substitute for MS SQL Server temp table is a reference cursor and/or collection types. SQL Server temp table is a memory structure, just like Oracle collection types. You just have to pray that your db drivers (ODBC, JDBC, .net, whatever) support those rather exotic constructs (I mean - really support, not just they are saying they are supporting).

BTW: "Oracle is VERY static database, we are developing total DYNAMIC application" - keep in mind that database is a data*BASE*! Basement is never dynamic! Application(i.e. functionality) - yes, it is dynamic. You can use the same building for many(not all!) purposes. This is one of the rather rare occasions when architectural analogy is really suitable for information technology. Do not mix Oracle support for putting code(stored procedures) into the database with the database itself!

Brgds, Laimis

-----Original Message-----
From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Gints Plivna Sent: 22. nóvember 2005 11:54
To: Dominik Smatana
Cc: oracledba.williams_at_gmail.com; DGoulet_at_vicr.com; dominik_at_ttsm.net; oracle-l_at_freelists.org Subject: Re: SELECT INTO new_table

There are many ways to achieve the same goal. It is true also in programming, and programming in Oracle (pl/sql, java whatever) as well. You should firstly understand at least the very basics how each database works and then most probably you won't even need those temporary tables. BTW why you need them? What is the reason behind?

And one more BTW - my name is Gints and I'm not starter of this thread ;)

Gints Plivna

On 11/21/05, Dominik Smatana <dominik.smatana_at_gmail.com> wrote:
> Thanks for all answers,
> my opinion: Oracle is VERY static database, we are developing total
> DYNAMIC application (MS SQL 2000 - no problems, Oracle 9.2i ->
> uuuuuffff!) :-)
>

--


--
http://www.freelists.org/webpage/oracle-l