Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: When does ROWID change ?
Jenda Krynicky <Jenda_at_Krynicky.cz> wrote in message
news:1103_941539499_at_prague_main...
> Is it safe to use a ROWID as a key for some table?
NO NO NO!!!!!!!!!!! ROW IDs are dynamic, and you have no control over them. There is no guarantee that any particular row will ever have the same row id. Remember that relational theory says that sets (data, in this case) are not stored in any particular order. Your data is in a bucket, not on shelves. It just so happens that most of the time, you have a very steady hand and can retrive the data from the bucket the same way you did last time, but there's no guarantee...
You may need to create an artificial key (such as a sequence number). Received on Tue Nov 02 1999 - 08:44:42 CST