>Hello all,
>
>is there an equivalent to the timestamp column of MS-SQL Server on the Oracle Server, that i can use in remote view's with UpdateType of 'KeyAndTimeStamp'?
Sergey is correct. The best you can do is add a Date column to every table and update its value with a trigger. I have a KEYID [Number(8)] and LAST_UPDATE [Date] Column in all my tables. The KEYID column is my PK column and is populated by using a sequence and the trigger as well:
create or replace trigger SCHEMA_TABLENAME_BEFORE_INSUPDT
before insert or update on Schema.TABLENAME for each row
declare
v_Id Number;
v_Date Date;
BEGIN
:new.Last_Update := SYSDATE;
If :new.KeyID Is Null or :new.KeyID < 1 Then
select s_Schema_TABLENAME.nextval into v_Id from dual;
:new.KeyID := v_Id;
End If;
End;
/
CREATE SEQUENCE S_Schema_TableName increment by 1 start with 1;
Mark McCasland
Midlothian, TX USA