• Post Reply
  • Bookmark Topic Watch Topic
  • New Topic

Entries getting placed in random rows

 
Ransika deSilva
Ranch Hand
Posts: 524
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
Hello,
I am a new commer to JAVA. I am using oracle as my database. I have this problem of when I
write data in to a table, entries get entered in random positions. I mean for example if there
are already 3 entries in a table and when i enter a new entry the new entry goes to the top
of the table other than appearing in the 4th row. Could you please tell me how to over come this.
Thank
 
Mark Spritzler
ranger
Sheriff
Posts: 17278
6
IntelliJ IDE Mac Spring
  • Mark post as helpful
  • send pies
  • Quote
  • Report post to moderator
As far as I know you cannot overcome this issue. It is how Oracle handles deleted records, and inserts. If it did not work this way, then your table size would increase as if all your deleted records were still there.
Insert order should have no effect in your queries. You just need to remember to have indexes where you need them, and order by in your queries.
Mark
 
  • Post Reply
  • Bookmark Topic Watch Topic
  • New Topic