From oracle-l-bounce@freelists.org Tue Nov 22 06:39:30 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id jAMCdTrC016382 for ; Tue, 22 Nov 2005 06:39:29 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id jAMCdOAX016325 for ; Tue, 22 Nov 2005 06:39:24 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 0DC5D2337D2; Tue, 22 Nov 2005 07:39:20 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 16119-10; Tue, 22 Nov 2005 07:39:20 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8B64F233529; Tue, 22 Nov 2005 07:39:19 -0500 (EST) Received: with ECARTIS (v1.0.0; list oracle-l); Tue, 22 Nov 2005 07:37:25 -0500 (EST) Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 21B752332B9 for ; Tue, 22 Nov 2005 07:37:25 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 16017-04 for ; Tue, 22 Nov 2005 07:37:25 -0500 (EST) Received: from proxy.HNIT.is (proxy.hnit.is [193.4.243.130]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D535E2331DC for ; Tue, 22 Nov 2005 07:37:23 -0500 (EST) Received: from HNIT-SEIFUR.HNIT.is ([193.4.243.94]) by proxy.HNIT.is with InterScan Messaging Security Suite; Tue, 22 Nov 2005 12:36:16 -0000 X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0 Content-class: urn:content-classes:message MIME-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: 8bit X-MIME-Autoconverted: from quoted-printable to 8bit by Ecartis Subject: SELECT INTO new_table Date: Tue, 22 Nov 2005 12:36:15 -0000 Message-ID: X-MS-Has-Attach: X-MS-TNEF-Correlator: Thread-Topic: SELECT INTO new_table Thread-Index: AcXvW1Rv3awy3+vLTQeYFuB4FvTWpQAAhLUQAAD5KpAFrom: "Laimutis Nedzinskas" To: X-archive-position: 28574 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: lnd@HNIT.is Precedence: normal Reply-To: lnd@HNIT.is X-list: oracle-l From: oracle-l-bounce@freelists.org X-Virus-Scanned: by amavisd-new-20030616-p9 (Debian) at avenirtech.net X-mailscan-MailScanner-Information: Please contact the ISP for more information X-mailscan-MailScanner: Found to be clean X-MailScanner-From: oracle-l-bounce@freelists.org X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Level: X-Spam-Status: No, hits=-4.7 required=5.0 tests=BAYES_00,NO_REAL_NAME autolearn=no version=2.63 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@freelists.org [mailto:oracle-l-bounce@freelists.org] On Behalf Of Gints Plivna Sent: 22. nóvember 2005 11:54 To: Dominik Smatana Cc: oracledba.williams@gmail.com; DGoulet@vicr.com; dominik@ttsm.net; oracle-l@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 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