since 10g upgrade, select results are incorrectly sorted. We use the value of a column in the primary key to sort the results. Now, when we insert a record in the middle of the table, let say in position 20, this new record is returned at the end of the select result, even if its value should put it at the 20th position.
The SELECT statement has no clause like "order by" or "sort", just SELECT ... FROM ... WHERE ... EQ
There are only 220 records in this table.
Thanks in advance.