jQuery in Action, 3rd edition
The moose likes JDBC and Relational Databases and the fly likes insert 650 fields into oracle table Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login
JavaRanch » Java Forums » Databases » JDBC and Relational Databases
Reply locked New topic

insert 650 fields into oracle table

Tom Griffith
Ranch Hand

Joined: Aug 06, 2004
Posts: 275
Hello. If anybody has a minute, is inserting that many data fields into an oracle row (it's a single table as far as i know) kind of crazy? I can't even imagine the single prepared statement to handle all that. Are there alternatives via jdbc? Thank you very much for reading this. Any input is greatly appreciated.
Amit M Tank
Ranch Hand

Joined: Mar 28, 2004
Posts: 257
Did you try it out with JDBC Prepared statement?

Amit Tank
Linked In
Chad Clites
Ranch Hand

Joined: Aug 16, 2005
Posts: 134
On the face of it, it seems unusual. I have never run across tables with that many columns, and I can't think of anything that would require that many fields in a single row. If all of the values are unique to that single entity, then I don't suppose it is out of the question to have a table that big. May I ask what sort of entities are being recorded?
Andrew Monkhouse
author and jackaroo
Marshal Commander

Joined: Mar 28, 2003
Posts: 11778

This topic is now closed, as it is a duplicate of this post, which has a bit more information from the original poster in it.

Regards, Andrew

The Sun Certified Java Developer Exam with J2SE 5: paper version from Amazon, PDF from Apress, Online reference: Books 24x7 Personal blog
I agree. Here's the link: http://aspose.com/file-tools
subject: insert 650 fields into oracle table
It's not a secret anymore!