Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> SQL Server rowversion or timestamp equivalent in Oracle 9i

SQL Server rowversion or timestamp equivalent in Oracle 9i

From: Najm Hashmi <najmhashmi_at_videotron.ca>
Date: Mon, 13 Dec 2004 12:36:45 -0500
Message-ID: <mskvd.19305$i3.704754@weber.videotron.net> 





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
Received on Mon Dec 13 2004 - 11:36:45 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US