Cleaning a table
566946May 28 2008 — edited May 28 2008Hi there. I need to do some data clean up in our table. basically, what I need to do is to find all the values in a certain column where an apostrophe is existing and then I need to escape it, make it \' instead of ' only. So if I have the value Testing's Test for the column order_name, the value should be change to Testing\'s Test. Im still trying to figure my way around Oracle, so Im just looking for some guidance here...
create table OrderTable(
order_id number primary key
order_dt date,
order_name varchar2(30),
order_description varchar2(100)
)