Re: adding col in between....

But I thought all java programmers ever need is a clob since they store everything in a big string.

On 7/19/05, Carel-Jan Engel <cjpengel.dbalert_at_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 comments. I, however have a preparedStatement() for them.

Raj

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