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

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Tue, 14 Dec 2004 16:49:46 -0800
Message-ID: <1103071673.433775@yasure>

yong321_at_yahoo.com wrote:

> 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

For a demo of Workspaces go to http://www.psoug.org click on Morgan's Library
click on DBMS_WM Synonym

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)

Received on Tue Dec 14 2004 - 18:49:46 CST