SELECT INTO new_table
- To: <Oracle-L@xxxxxxxxxxxxx>
- Date: Tue, 22 Nov 2005 12:36:15 -0000
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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx] On
Behalf Of Gints Plivna
Sent: 22. nóvember 2005 11:54
To: Dominik Smatana
Cc: oracledba.williams@xxxxxxxxx; DGoulet@xxxxxxxx; dominik@xxxxxxxx;
oracle-l@xxxxxxxxxxxxx
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@xxxxxxxxx> 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!) :-)
>
--
--
//www.freelists.org/webpage/oracle-l
Other related posts:
