Are you worried about every possible combination of wild cards or the ones that are most likely to cause Oracle errors when you run straight sql against the data.You could do the following.

update t1 set c1 = replace(t1, '''', '"');
commit;

Just make sure you give yourself a lot of rollback

You can also create a insert and update trigger to replace any new ' that get put into production.