Re: instability when inserting data
thierry delahaut wrote:
> I have observed several times some instability when inserting new data in a table, meaning the
> new data are placed at the beginning of the table, not the end. this is big problem, because these
> data are dated.
By definition, records in a relational table are *unordered*.
> could you tell me if there is a way to prevent that ?
Include e.g. a timestamp in your table, a use an ORDER BY clause when you retrieve records.
--
felix
Please use
BBCode to format your messages in this forum.
Subject
Written By
Posted
Re: instability when inserting data
June 27, 2005 01:35AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.