Re: Equivalent to rowid in Oracle...

Tech-Archive recommends: Fix windows errors by optimizing your registry

From: Tenaya (ct_at_ct.ct)
Date: 03/21/04 

Date: Sun, 21 Mar 2004 13:00:14 -0500

Greg,

I believe there is a significant difference between the SQL Server Timestamp
(aka RowVersion) data type and the Oracle RowID property.

As I understand it, and I am willing to be corrected by anyone with superior
knowledge, the Oracle RowID property is an internal value that allows Oracle
to quickly locate the physical location of a row. As such, it is independent
of the values contained within the row itself. In other words, one can issue
multiple UPDATEs to an Oracle row, and the RowID will not change.

As I'm confident you are aware, an UPDATE to a row containing the Timestamp
datatype changes the value of the Timestamp column.

Chief Tenaya

"Jaxon" <GregoryAJacksonN0SPAM@hotmail.com> wrote in message
news:eencRb2DEHA.1240@TK2MSFTNGP10.phx.gbl...
> SQL Server does support a RowVersion DataType. Most often referred to as
> TimeStamp.
>
> I dont know JACK about Oracle, but I believe this is what you are looking
> for.
>
>
> cheers,
>
>
> Greg Jackson
> PDX, Oregon
>
>