i've got an issue - when i import data from oracle, i get a weird symbol '
' char(2) in some cells. i want it to be replaced by _ (underscore). in my opinion, the easyest way to do this is to write a stored procedure which takes a table name as parameter, scans all non-numeric columns for this symbol and replaces it. it should execute sql similar to this:
UPDATE sometable SET column1=REPLACE(column1,char(2),'_'), column4=REPLACE(column4,char(2),'_')
the problem is, each table has different columns, and i can't find a way to get their names and types.
maybe stored procedure is not the best way to solve my problem? any help would be appreciated.