Bookmark Topic Watch Topic
  • New Topic

insert 650 fields into oracle table

 
Tom Griffith
Ranch Hand
Posts: 275
  • Mark post as helpful
  • send pies
  • Report post to moderator
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
Posts: 257
  • Mark post as helpful
  • send pies
  • Report post to moderator
Did you try it out with JDBC Prepared statement?
 
Chad Clites
Ranch Hand
Posts: 134
  • Mark post as helpful
  • send pies
  • Report post to moderator
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
Pie
Posts: 11943
212
C++ Firefox Browser IntelliJ IDE Java Mac Oracle
  • Mark post as helpful
  • send pies
  • Report post to moderator
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
 
    Bookmark Topic Watch Topic
  • New Topic