sure ok but do i need to write 60 merge statements and what if the table structure changes or a table is added/removed


easy enough to select from user_tab_cols
to
MERGE into EVENT
USING (SELECT * from EVENT where EVENTID > 10000)
WHEN NOT MATCHED THE INSERT INTO event a SELECT * FROM event b
WHEN MATCHED THE UPDATE SET....

the UPDATE is the problem, how can I dynamically build the update at run time from a query on user_tab_cols