Re: What is the rowid composed of?

From: Ed Prochak <ed.prochak_at_magicinterface.com>
Date: 19 Oct 2005 10:33:21 -0700
Message-ID: <1129743201.646130.96020@g44g2000cwa.googlegroups.com>

Robert Wehofer wrote:
> Hello!
>
> I would like to know, how Oracle creates the rowid for a SELECT statement.
> Would there be the same rowid for each dataset if the statement is going to
> be executed several times with same result?
>
> Regards,
> Robert

A more fundamental question is WHY do you want to know?

What goal are you seeking to achieve? I found very few cases for using ROWID truly helpful. Most are downright harmful in the sense that you lose any ability to export and import the data.

So again what do you want to do with the ROWID???

Ed Received on Wed Oct 19 2005 - 12:33:21 CDT