aspose file tools*
The moose likes JDBC 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


Win a copy of Java 8 in Action this week in the Java 8 forum!
JavaRanch » Java Forums » Databases » JDBC
Reply locked New topic
Author

insert 650 fields into oracle table

Tom Griffith
Ranch Hand

Joined: Aug 06, 2004
Posts: 257
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: 11285
    
  59

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
 
jQuery in Action, 2nd edition
 
subject: insert 650 fields into oracle table
 
Similar Threads
Oracle date-time fields
Date Insertion using XSU...
MERGE Statement in Oracle 10G on a single table
open source database relational browser?
insert 650 fields into oracle table