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@xxxxxxxxx> 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