This content has been marked as final. Show 1 reply
OK so here is my current workaround:
Create a standard "Table or Row Copy" Startup Process with a WHERE condition. Take note of the target table e.g. "TMP$MY_PACKAGE.MY_TABLE".
Add a "User PL/Sql Code" Teardown Process with something like this code:
MERGE INTO MY_TABLE A
USING "TMP$MY_PACKAGE.MY_TABLE" B
ON (A.ROWID = B.SRC$ROWID)
WHEN MATCHED THEN
UPDATE SET A.COLUMN_1 = B.COLUMN_1; -- List all columns requiring updating
EXECUTE IMMEDIATE 'DROP TABLE "TMP$MY_PACKAGE.MY_TABLE"';
Limitation is that you have to specify all columns to update. Also insert & delete are not catered for, but you could code that in as well.