Re: Using rowid in a html anchor / select statement

In article <324fe2e7.5421665_at_dcsun4>, Thomas J. Kyte <tkyte_at_us.oracle.com> wrote:
>
>As for rowid being fluid - ****the rowid of a row will never change**** unless
>the row is deleted and re-inserted. Oracle basic replication counts on rowid.
>Oracle Forms counts on rowid. The rowid of a row is a value that will not
>change. The only way a rowid will change is if you physically delete and then
>reinsert the row (but then it is not the same row anymore anyway).

While I could live with the rowid changing if you deleted and then re-created a row, isn't it true that some other new record could get the same rowid as a record you just deleted? It wouldn't be so bad if a rowid was never reused. It shouldn't be that hard to maintain referential integrity within the Oracle database, but if you use a rowid outside the database (like in a web page), there's no guarantee it'll point to the right record later on.

--
Steve Kanefsky