Untested:

s/("[^"]*")|,/$1||"|"/eg;
[download]

This ought to replace any comma outside double quoted strings with a pipe.

That doesn't mean it will munge your data into something Oracle accepts.

Are you sure Oracle cannot be told what to use as delimiter?