Re: Looking for the Oracle equivalent to MS SQL Server timestamp field
Date: Tue, 18 Feb 2003 22:00:05 -0500
Message-ID: <eis55vg4du05gd4dps9pi3bvh12nk707hk_at_4ax.com>
try sysguid.
Some people will recommend using sequences. A completly random number
like sysguid (Oracle claims that the generated number will be unique
on universe not only on your federation of servers) is more efficient
for a b-tree index(less branches), so even if the sysguid is a raw
data (is bigger than a number) the index will be fastest finally.
On 18 Feb 2003 11:36:24 -0800, aguptill_at_nxtrend.com (Arch) wrote:
>I'm looking for the Oracle data type and possibly method to shadow the
>MS SQL Server timestamp data type.
>
>From SQL Server Online help a timestamp is defined as:
>timestamp is a data type that exposes automatically generated binary
>numbers, which are guaranteed to be unique within a database.
>timestamp is used typically as a mechanism for version-stamping table
>rows. The storage size is 8 bytes.
>
>I'm not necessarily concernd that the datatype stays binary but the
>funcationality is what I'm after. In particular is the notion of
>ensuring that I can tell if a record has been updated since the data
>was pulled that I'm now working with and possibly updating back to the
>db system.
>
>Thanks in advance.
>Arch
Received on Wed Feb 19 2003 - 04:00:05 CET