In Oracle i am using ORA_ROWSCN function instead of SQL SERVER's Timestamp...

Its very easy to use..

When you create a table you can add ROWDEPENDENCIES command.

For Example...

SQL> CREATE TABLE TEST001(

2 TESTID NUMBER,

3 TESTNAME VARCHAR2(25))

4 ROWDEPENDENCIES;

Table created.

SQL>

SQL> INSERT INTO TEST001 VALUES(1,'DEMO');

1 row created.

SQL> COMMIT;

Commit complete.

SQL> select ORA_ROWSCN,TESTID,TESTNAME from TEST001;

ORA_ROWSCN TESTID TESTNAME

---------- ---------- -------------------------

5066802 1 DEMO

SQL>

SQL> update TEST001 set TESTNAME = 'TEST' WHERE TESTID = 1;

1 row updated.

SQL> COMMIT;

Commit complete.

SQL> select ORA_ROWSCN,TESTID,TESTNAME from TEST001;

ORA_ROWSCN TESTID TESTNAME

---------- ---------- -------------------------

5066883 1 TEST