Re: SQL Server rowversion or timestamp equivalent in Oracle 9i

Najm Hashmi wrote:
> Hi All,
> I need to migrate a SQL Sever Database to Oracle 9i. I am just
curious what
> equivalent of SQL Server timestamp datatype in Oracle. Or how I can
> implement similar behavior in 9i. I am sure Oracle must have very
elegant
> way to handle such situation.
>
> " 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."
>
> Thanks in advance.
>
> Najm

Other than using the SYS_GUID function (Mark's suggestion), how about Oracle workspaces? Sorry I don't have actual experience. The manual says "...provides an infrastructure that lets applications conveniently create workspaces and group different versions of table row values in different workspaces. Users are permitted to create new versions of data to update..."

Yong Huang Received on Tue Dec 14 2004 - 10:59:29 CST