When i compare the data of 2 tables between 2 different oracle database servers and one of column of the row has been updated, the sync scipt generates an update statement, however, the where clause has a rowid, Is there a way to to use the Primary key value rather than the rowid.
This is the update statement that is generated, which is perfectly valid,
UPDATE MY_SCHEMA.TAB:MY_TABLE SET TESTLIST_NM = ‘This is a test’ WHERE ROWID = ‘AAAYgeAALAAAAHlAAI’;
However i would like the where clause to have the name of the Primary Key and the value, as below (TESTLIST_CD is the Primary Key column)
UPDATE MY_SCHEMA.TAB:MY_TABLE SET TESTLIST_NM = ‘This is a test’ WHERE TESTLIST_CD = ‘CODE_O1’;