From oracle-l-bounce@freelists.org Tue Jul 19 06:45:52 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j6JBjqt9023267 for ; Tue, 19 Jul 2005 06:45:52 -0500 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 j6JBjiIP023225 for ; Tue, 19 Jul 2005 06:45:44 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E1AAC1D6F5F; Tue, 19 Jul 2005 05:51:03 -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 27725-01; Tue, 19 Jul 2005 05:51:03 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 60A5C1D6C7B; Tue, 19 Jul 2005 05:51:03 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:references; b=Et3IKzTzMz5AK6oIhjhCHQ/6hvziLJXB8dKANgbA3cv9TS4/uIf9CyT69MZo36U98Ml50sSmsPPClCKM1dbwR/2KTXvS/XlAnqhGlnWZ5282hVunl8jQP9hASUhCbfb6wKhV6HMjlwMynqrpUCXJrephOXStetSfXhizpuRPjKs= Message-ID: <9177895d0507190348746f4ecb@mail.gmail.com> Date: Tue, 19 Jul 2005 06:48:02 -0400 From: rjamya To: cjpengel.dbalert@xs4all.nl Subject: Re: adding col in between.... Cc: Lex de Haan , onkarnath.tiwary@gmail.com, "oracle-l@freelists.org" In-Reply-To: <1121767530.6428.7.camel@dbalert199.dbalert.nl> Mime-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_1360_6705124.1121770082588" References: <20050719091553.CBFA41D1BFC@turing.freelists.org> <1121767530.6428.7.camel@dbalert199.dbalert.nl> X-archive-position: 22646 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: rjamya@gmail.com Precedence: normal Reply-To: rjamya@gmail.com X-list: oracle-l 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-Level: X-Spam-Checker-Version: SpamAssassin 2.63 (2004-01-11) on air891.startdedicated.com X-Spam-Status: No, hits=-3.3 required=5.0 tests=AWL,BAYES_00,HTML_MESSAGE autolearn=ham version=2.63 ------=_Part_1360_6705124.1121770082588 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline But I thought all java programmers ever need is a clob since they store=20 everything in a big string. On 7/19/05, Carel-Jan Engel wrote: >=20 > Maybe the 'why' question can be answered. I was involved in a project,=20 > where all queries were 'select * from.....'. And all updates updated ever= y=20 > single column, of course, whether the contents changed or not. >=20 > Yes, it was Java. They 'generated' the SQL, and required all columns to b= e=20 > in alphabetical order.=20 Yeah, time to fire the dumb design and bring in some natural commen sense= =20 back. I'd never let java programmers design anything, just let them=20 implement a prepared design.=20 Okay, now I'll wait for java programmers to 'throw' exception at my=20 comments. I, however have a preparedStatement() for them. Raj ------=_Part_1360_6705124.1121770082588 Content-Type: text/html; charset=ISO-8859-1 Content-Transfer-Encoding: quoted-printable Content-Disposition: inline But I thought all java programmers ever need is a clob since they store eve= rything in a  big string.

On 7/19/05, = Carel-Jan Engel <cjpen= gel.dbalert@xs4all.nl> wrote:
Maybe the 'why' question can be answered. I was involved in a project, where all queries were 'select * from.....'. And all updates updated every single column, of course, whether the contents changed or not.

Yes, it was Java. They 'generated' the SQL, and required all columns to be = in alphabetical order.

Yeah, time to fire the dumb design and bring in some natural commen sense back. I'd never let java programmers design anything, just let them implement a prepared design.

Okay, now I'll wait for java programmers to 'throw' exception at my comment= s. I, however have a preparedStatement() for them.

Raj


------=_Part_1360_6705124.1121770082588-- -- http://www.freelists.org/webpage/oracle-l